Jim Why not when you are loading the temp table just set the Shipdate to null before using the form.
UPDATE tBOLHeader SET Shipdate = NULL Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, December 04, 2009 11: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
