This is the relevant code:
declare inRows cursor for +
select Clientid,LASTNAME,FSTNAME,m_i_,MaidenName from CCClientsStage2
OPEN inRows
FETCH inRows into vClientid, vLastname, vFstname, vMI, vMaidenName +
indicator vIndicator
.
.
.
set var vFullName = .vLASTNAME+ ',' & .vFSTNAME& .vMI
set var vMainID = clientid from maininfo where +
tot_name = .vFullname
Tot_Name is a field that concatenates Lastname, Fstname and MI. I had
originally tried the comparison using each variable to each field. Lastname and
Fstaname always have a value. MI is often blank. In the concatenated field, I
just see nothing when there is a blank in MI, but in the variable I see -0-
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy
Sent: Sunday, February 17, 2013 4:28 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Variable in Cursor
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.
