Kayza
How are you comparing the null value. Also make sure you are using the
indicator when selecting values from the column
FETCH c1 INTO varName INDIC ivarName ....
IF varName IS NULL THEN
Do something here
ENDIF
You could also test for NULL
IF ivarName = -1 THEN
Do something here because varName IS NULL
ENDIF
Hope this helps.
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Kayza
Kleinman
Sent: Sunday, February 17, 2013 3:33 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Variable in Cursor
I have a cursor set up and I'm comparing the values in the cursor to values
in a different table. The problem is that when I pull the values in the
cursor into variables, if the value in the column is null, the value of the
variable shows up as a literal -0-. This is a problem because the when I do
a comparison to the main table, it doesn't work. When there is a value it
does work.
Any ideas?
Kayza Kleinman
CIO &
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax 718 946-8240
http://kayzasblog.nphd.org/
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>
Helping you do good - better.
