Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cancel edits
Message
From
25/04/2000 22:39:33
 
 
To
25/04/2000 15:58:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00363305
Message ID:
00363417
Views:
16
>Thanks Al,
>
>I have tried it with tablerevert but it still is saving to the table. The control sources of my textboxes on the form are the table and the corresponding fields. This is the code I have in my cancel button now.
>
>set multilocks on
>= cursorsetprop('buffering', 5, 'centhead')
>tablerevert(.T.)
>go prevrec
>thisform.refresh
>
>Any more ideas as to why it's saving to the table?
>
>Thanks,
>Tyler

You need to take a closer look at buffering and how it works with TABLEUPDATE() and TABLEREVERT(). In a nutshell, you make sure buffering is turned on BEFORE you do your edits; that way you're working with a copy of your table's fields, not the values themselves. You can then choose to save the changes with TABLEUPDATE(), or discard them with TABLEREVERT().

Check out the references I gave you earlier.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform