Steve,
Not sure that you can do it the way that you are trying - but maybe somebody
can prove me wrong...
In the mean time, this is the way that I would do it:
IF vendor2 IS NULL THEN
UPDATE [tablename] SET vendor2 = .v_vendor2
ELSE
CLEAR VAR v_vendor2
ENDIF
Regards,
Alastair.
----- Original Message -----
From: Steve Breen
To: RBASE-L Mailing List
Sent: Sunday, November 30, 2008 2:05 PM
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
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.9.11/1820 - Release Date: 29/11/2008
18:52
