New using progress.

Marisa · #1 (**permalink**) 04-30-04, 17:01

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!!

JohanSamyn · #2 (**permalink**) 05-01-04, 09:00

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

Marisa · #3 (**permalink**) 05-03-04, 16:24

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.

PEGMGR · #4 (**permalink**) 05-05-04, 02:34

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

brbogdan · #5 (**permalink**) 05-07-04, 06:40

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

Internet Services

Web Development

Digital Marketing

Consumer Tech