Search results

  1. J

    Splash Window

    Hi, I have found some code on PSDN to create a splash window. http://www.oehive.org/node/403 This procedure was developed by Jurjen Dijkstra in 1997 on Progress 8.2A. The problem is this code uses {windows.i} and I cannot find this file in OE10.0B. Is there any alternative? Can...
  2. J

    Export to excel file

    I beg to differ Lord. This is beginner's level question and the answer should be straight forward. It seems that replies 1 & 2 are to the point and appropriate at this level. While Sridevi has given a complete procedure, this may not be newbie's requirement. ;) Jongpau's reply may not be what...
  3. J

    Three Tier Architecture

    Thanks Tomhas. I have found a document on PSDN which is informative for the basics. http://www.psdn.com/library/servlet/KbServlet/download/3264-102-6077/INT-10_LundBonser.ppt I have just configured a Name Server and AppServer and started working on it. :)
  4. J

    Three Tier Architecture

    Hi All, Where can I get some idea of setting up a three tier architecture [databse server - Application Server (for Business Logic) - Client PC] with OpenEdge. Please help. Thanks in advance!
  5. J

    table buffer

    Hi Elise, One use may be passing a table handle to a procedure to perform similar action on a number of temp-tables.
  6. J

    Break By Vs. By

    Or in other words, if you just want to sort "BY" is sufficient. But for doing some kind of aggregates "BREAK BY" can be used.
  7. J

    new learner

    Hi, For understanding the basic programming and Data Structures, C is the best choice I think and for OO concepts C++. That gives one a solid base. When you change language later, you just need to learn the syntax of the language. When working in Progress 4GL and ABL I enjoyed its speed...
  8. J

    How to set the mask for a date in excel

    If you have not solved this already, you can try the following: CREATE "Excel.Application" chExcelApplication. chWorkBook = chExcelApplication:WorkBooks:ADD(). chWorkSheet = chExcelApplication:Sheets:ITEM(1). chExcelApplication:Sheets:ITEM(1):SELECT. chExcelApplication:cells:Select...
  9. J

    new learner

    My experience is that Progress Technology is easy to start with. And like all other technologies there are challenges when you go deeper. Concepts of programming is a different topic. That is a common base what you need when you try to do some coding. Whether it'll be easy for you will depend...
  10. J

    Export to excel file

    ASSIGN vExcelFilePath = "C:\FolderName\FileName.xls". IF SEARCH(vExcelFilePath) <> ? THEN OS-DELETE VALUE(vExcelFilePath). chWorkSheet:SaveAs (vExcelFilePath,,,,,,,,). You can try the above.
  11. J

    Delete dynamic tablename

    Empty Temp-Table statement is sometimes troublesome especially if you try to empty that in the middle of a transaction. The better way is to delete records using for each statement. However, there may be second opinions. ;)
  12. J

    Progress 8.3 dump to SQL Server 05

    Hi Tom, I don't need to worry about licensing issues in our company. So I am a bit ignorant on this. But now I want to know about licensing issues coz I am planning to sale software developed by me. Can you please help me about where I can find documents on license costs? As for XML, I am...
  13. J

    New to Progress

    This is difficult to answer. I had prior programming experience in SQL92 and C/C++. Therefore I started by opening the source codes of the Point of Sale software that my company uses. However, there are lots of manuals you can find on net. You may look in http://www.psdn.com. Happy hunting!!
  14. J

    Progress 8.3 dump to SQL Server 05

    ODBC Connectivity, XML, and CSV all are possible options. But if you are new to Progress Development, CSV should be the ideal choice. The following code should dump a table in CSV format. Output To "C:\OUTPUT.CSV". For Each MyTable No-lock: Export Delimiter "," Mytable. End. Output...
  15. J

    How to Create Accsess Database and Table

    One way is to create a ODBC Connectivity with proper database authorization (e.g. READ UNCOMMITTED) and create linked tables or tables in MS-Access database corresponding to Progress tables.
  16. J

    Sending SMS

    Seems that you generate a string which is mailed to the exchange server from where it is sent as sms to the recipients. An alternative is to generate the message in the text or .xls format and send the message through a third party tool and service. I have developed a similar system with good...
  17. J

    Insert Image onto Multple Sheets in Excel

    You can try the following: chWorkSheet = chExcel:Sheets:Item(xwrkshtNo). chWorkSheet:Select. chWorkSheet:Range("A2"):select. chWorkSheet:Pictures:Insert("picture.jpg"):select. chWorkSheet:Range("A:A"):ColumnWidth = 7.57. :)
  18. J

    Excel CheckBox help

    Please try the following: chExcel:Sheets('sheet1'):checkbox3:Value = True . :)
  19. J

    barcode printing and picture

    One solution is to generated the barcode details in .txt format from an Application interface (developed in Progress 4GL) . Any standard barcode printing software e.g LabelWorks can do the rest. LabelWorks has excellent interfacing with barcode printers. e.g. Z4M Plus.
  20. J

    Identifying Input Device

    The swiping devices we are using uses "%" or "c10" as starting characters. But these can be easily found out by anybody if they swipe their card in any text editor. After knowing a card number and default starting character for a swiping device, an unscrupulous person can easily type in the...
Back
Top