var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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!!
In Progress the functions TODAY and TIME provide system-date and system-time, as in :
Hope this helps ...
def var dtThisDay as date no-undo.
def var iThisMoment as int no-undo.
assign dtThisDay = today
iThisMoment = time.
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.
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
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.