Search results

  1. S

    What is the ideal data type to use when storing latitude/longitude (Geo Co-ordinates)

    Hello, I need to store the geographical location in Progress database. Please let me know as to which would be the ideal data type which can be used to store this information. Thanks Kiran Shankar
  2. S

    Exporting to Excel

    Try something like this vchWorkSheet :range("a1:d1"):FONT:bold = TRUE. /* Make first row BOLD */ vchWorkSheet :range("a1:d1"):FONT:ColorIndex = 22. /* Change Font color*/ These URLs contain more examples, http://herohog.com/Progress/Excel2.p http://herohog.com/Progress/Excel3.p...
  3. S

    Exporting to Excel

    Probably something like this?? The below code exports some fields from customer table in the sportsdatabase. DEF VAR vchExcel AS COM-HANDLE NO-UNDO. DEF VAR vchWorkBook AS COM-HANDLE NO-UNDO. DEF VAR vchWorkSheet AS COM-HANDLE NO-UNDO. DEF VAR vRow AS INT NO-UNDO. CREATE "Excel.Application":U...
  4. S

    Basic Question

    Use the format with output. Something like put vTxt FORMAT "x-xx-xx-xxxx". Thanks - Kiran.
  5. S

    Problem with Break By statement

    Try converting the date to string, for each ar_mstr break by (IF v-sortby = "I" THEN ar_nbr ELSE STRING(ar_date)): disp ar_mstr with 2 col. end. Thanks
  6. S

    Xref

    Xref specifies the file where the Application Compiler writes cross-reference information between source files and database objects.xref. For each object reference, the .xref file contains one unformatted and blank-separated line containing the following: 1) Procedure name 2) Source filename...
  7. S

    Not able to start db

    Murthy, I do not have much idea on the problem you have mentioned. However I did find the below mentioned information at psdn site. HTH. ID: P4592 Title: "Errors 860 and 5292 trying to start a database" Created: 07/12/2002 Last Modified: 10/16/2008 Status...
  8. S

    How to improve performance

    if the condition check is based on a field of table which is being used in the FOR block, You can use CASE statement.
  9. S

    probkup

    Full Backup A full backup backs up all of the data of a database, including the BI files. You can perform a full backup using either the PROBKUP utility or an operating system utility. Ideally, you should perform a full backup of your database every day. However, depending on your recovery...
  10. S

    Authentication Solution

    The attached document should be able to get you started. Thanks - Kiran
  11. S

    Temp-table blank record

    The attached document gives more information on why a blank record was created. - Kiran
  12. S

    Group by and sub total

    Hello JP, Yes the solution provided above by Joey did help me. I was able to achieve what i wanted. Thanks Kiran
  13. S

    Group by and sub total

    Thanks Joey!!
  14. S

    Group by and sub total

    I need to populate temporary table from a database table. The records of the table are somthing like this Country Type Amount ------------------------------ Ind FNT 10 Ind FNT 9 Ind FGH 1 Ind Sales...
  15. S

    9.1c to Open Edge 10.0

    Hello, I found this Microsoft on the Internet addressing migration to PROGRESS version 10, Find attached the same and hope this helps. Thanks and regards Kiran Shankar
  16. S

    Extract table name & field

    Hello vineet, did you try something like this: FOR EACH _file NO-LOCK: IF _file-name BEGINS "_" THEN NEXT. FOR EACH _field OF _file NO-LOCK: disp _field-name. end. end. i hope this works -kiran
  17. S

    On-line Testing for Progress Skills

    online knowledge testing engine for PROGRESS May be this site will be of some help to you , http://www.progress-plus.com/ktest.htm you will have to create a user id and password to get access to all the tests Thanks and regards kiran shankar
  18. S

    Application Server 24344 error.

    Hello, We are using web based application which talks to Progress Appserver using CORBA interface. The CORBA component (eg.CRM3.1) will call progress programs with input and out parameters. This application used to work fine until we introduced a new CORBA component ( version CRM3.2) of the web...
  19. S

    Progress 9.1X and multi threading

    Toby, Thanks for your reply. We are looking for Multi Threading on Server Side. Can you please provide more information on how to proceed on this. Thanks, Kiran Shankar
  20. S

    Progress 9.1X and multi threading

    Hi, Can any one tell me if progress 9.1X version supports Multi Threading like Java. Thanks In Advance Kiran S Shankar
Top