Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Smile Unanswered: New using progress.

    Hi, i use sql server2000 but now i need to connet to a progress database via odbc. I did the connection but i need to know how to get the system date and time using the progress sintaxis'.

    Could someone can help me and tell me how to do that??

    thanks lot for your help!!

  2. #2
    Join Date
    May 2004
    Posts
    1
    Hi Marisa,

    In Progress the functions TODAY and TIME provide system-date and system-time, as in :
    Code:
    def var dtThisDay as date no-undo.
    def var iThisMoment as int no-undo.
    assign dtThisDay = today
           iThisMoment = time.
    display dtThisDay
            string(iThisMoment,"hh:mm:ss").
    Hope this helps ...

    Johan

  3. #3
    Join Date
    Sep 2003
    Posts
    5

    Smile New using progress.

    Thanks a lot for your help. I have an other question. I need to execute the query from sql server, so is valid to do this:

    select * from openquery(LINKEDSERVERNAME, 'select * from pub.JOURNAL where campofecha >= TIME')

    Sql server use the openquery function to execute queries in the linked server that is conected in via odbc to progress.

    Thanks a lot for your help.

  4. #4
    Join Date
    May 2004
    Posts
    4

    PEG Servers Forum

    You mayt want to check out the PEG Servers forum on PEG.COM .

    The Progress E-Mail Group, PEG, is one of the world's largest Progress User Group. http://www.peg.com

  5. #5
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    Progress implementation of SQL-92 (that is being used by your ODBC application) does not offer openquery function. Moreover this function is not a part of SQL-92 standard it is just Microsoft extension only.
    Regards
    Bogdan Brzozowski

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •