insert system date in quiz query

[Edis, Bob]

G'day Scott

You don't say what environment you are working in, and that would be
helpfull.

I will assume you are reading the data from a RDBMS.  In that case you will
probably have to use the appropriate database function to return the system
date rather than use the PowerHouse system date syntax.

E.g. (if souce is MS SQL Server)

SELECT portfolio, getdate() FROM pf_secs
 
Regards,
Blue

-----Original Message-----
From: scott wagler
To: powerh-l@lists.swau.edu
Sent: 9/25/2002 10:20 AM
Subject: insert system date in quiz query

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


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.