Recent content by ss_kiran

  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
Top