IF .vPreviousShip IS NOT NULL THEN Should be IF vPreviousShip IS NOT NULL THEN
RSTYLE should tell you this is a problem Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, December 04, 2009 10:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Change date to NULL Another simple problem my brain cannot seem to solve. We may ship from the same order more than once which means more than one bill of lading with different shipdates. When I bring up my information into the form (based on a temp table), I get it from the OrderHeader table. If there is a previous shipment, there will be a shipdate in the field shipdate on the form. What I want to do is once the info is in the form, I want to change the shipdate to a null in the temp table. (I will update that date later after the verification process) I have tried this code in an EEP SELECT Shipdate INTO vPreviousShip INDIC ivPreviousShip FROM tBOLHeader IF .vPreviousShip IS NOT NULL THEN PROPERTY Comp_ShipDate TEXTVALUE '-0-' CLEAR VAR .vPreviousShip ENDIF Any help appreciated. Jim
