Add Null value to cursor

[Edis, Bob]

G'day Bert

Try using a CAST() function on the item.  E.g. CAST('' AS NULL) AS test

Blue

-----Original Message-----
From: bert.dn@arma.nl [mailto:bert.dn@arma.nl]
Sent: Thursday, March 07, 2002 8:01 AM
To: PH listserver
Subject: RE: Add Null value to cursor


Hi all,


In a cursor (Oracle)  I would like to add an extra column with value "NULL"

As NULL is a reserved word I need to enclose it in double quotes ( Yes,I did
RTFM!)
However PH keep complaining that the column cannot be found.

sql in AL_DB declare CURSOR_TEST cursor for          &
select CONTRACTNR , NAWNR , "NULL" as test           &
  from CONTRACT_GEG                                  &
 where CONTRACTNR = 2002017030

access CURSOR_INVERZEKERING

*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-RBI_COLUMN, Column NULL was not found.


When I do this directly in SQL there is no problem.

Any suggestions?

Bert de Nooij




= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.