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