[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQLBase & SQR Help
At 04:31 PM 1/7/98 -0800, you wrote:
>I need to know how to access the current date in an
>SQR Batch program that is connecting to a SQLBase
>database.
You can just write a select statement to give
you the date right from SQLBase. I'm not familiar
with SQLBase per se, but there is probably a table
with one row, or a dummy table (like DUAL in Oracle).
You can right a select in a procedure like:
begin-select
SYSDATE &Date
move &Date to $Date
from DUAL
end-select
Hope this helps,
Jeremy
---
Jeremy C. Radwan <jradwan@concentric.net> -
http://www.concentric.net/~jradwan/
"Although it is not exactly 'real,' 'cyberspace' is a genuine place. Things
happen
there that have genuine consequences." - Bruce Sterling, "The Hacker
Crackdown"