insert system date in quiz query
scott wagler
stonecold99@hotmail.com
Wed, 25 Sep 2002 11:20:40 -0400
hello everyone,
i am trying to add the system date as a column in a cursor in QUIZ. i am
trying a simple query that will have the date inserted into each record.
since SYSDATE is a reserved word i was hoping i could just include it in
double quotes. here is what i've tried including the error:
>cancel clear
>sql declare sec_pos cursor for &
>select pf_secs.portfolio, "SYSDATE" from pf_secs
>access sec_pos
*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-RBI_COLUMN, Column SYSDATE was not found.
any help here would be greatly appreciated, thanks.
scott.
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com