Assign a temporarily variable

[D2C]

Hi there,

I would like to make a function that secures the data in my tables.

Let's say I have a form with two textboxes, name(name) and family name (famname).

If the user clicks on an edit command button, I want to store the data that was currently in the text box (originally from the database) in a temporarily variable, xname and xfamname.
After the user has completed his change, he should click on a button to store the changes in the database. So the temporarily variables will overwrite the data from the cell in my table.

Can somebody help me out on this one, because I do not have any clue on how to start...

tnx a billion,

greetz,
D2C

 

[jimstarr]

If I understand you correctly I think you can accomplish what you want by using table buffering (see CURSORSETPROP()). If the table is buffered you can save the changes via TABLEUPDATE() or cancel them via TABLEREVERT().

Jim