Hi Koos,

What you need to look into is Buffering. For single record updates you can use Optimistic Row Buffering and for multiple records you could use Optimistic Table buffering. Buffering will provide you the box to change the data at the interface and will not update anything at the backend unless you want to i.e. by using TABLEUPDATE()

To revert back to the last changes you can use TABLEREVERT()

Moreover, also look into BEGIN TRANS, END TRANS and ROLLBACK as they are an important part of making sure that the data is saved as a transaction.

>Hello,
>
>We are using VFP 5.0 and we are discussing what the procedures for the controls of data entry forms should be.
>In FP2.6 we always worked with variables on the screen.
>When SAVE was pressed the validation of the fields was done and a APPEND BLANK and/or GATHER was done. This worked fine for new and existing records.
>Now in VPF this does not seem to be the road anymore. Question is what is the best way now ?
>
>Greetings,
>
>Afier Appelman
>Using the account of Koos Veel