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 > > >
