> Am I on the right track? > > ** this is the button EEP > UPDATE inslogb SET iamount = (iamount + (-.vchprice)), ck_num = .vcknum,+ > lognotes = ((CTXT(.#DATE)) & .vinampd & CTXT(.vchprice) + lognotes) + > WHERE custnum = .cust# ........
You need to precede your UPDATE statement with a SAVEROW or PROPERTY TABLE TableName POST statement to save the existing changes to the row. Then issue the UPDATE. Then use PROPERTY TABLE TableName REFRESH to load the updated information into the form. Alternatively, if all the fields you want to update are DBEdits, you can get rid of the UPDATE statement and replace it with multiple calls to PROPERTY ComponentID TEXTVALUE .vValue. The advantage to this method is that the changes will not be saved until you move out of the row -- more like how regular typing on the form works. -- Larry
