As I said, I knew it was simple. I use the '-0-' instead of the ''.
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, December 04, 2009 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Change date to NULL Since it's a temp table, couldn't you make the shipdate null before you go into the form? But if not: PROPERTY compid TEXTVALUE '' will work. That's 2 single quotes (assuming that's your character) without a space in the middle. Karen 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
