Steve, You'll have to do this:
IF VENDOR2 = NULL THEN SET VAR VENDOR2 = .V_VENDOR2 ELSE SET VAR V_VENDOR2 = NULL ENDIF Claudine ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Sunday, November 30, 2008 8:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - IF NULL STATEMENT OR QUALIFIER I am trying to set vendor2 = v_vendor2 if vendor2 is null and if vendor2 is not null then I want to clear var v_vendor2. I started with this so far. not sure where to go from here? vendorn = (ifnull(.v_vendor Steve --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
