Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pessimistic table buffering - VFP8
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Pessimistic table buffering - VFP8
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01195247
Message ID:
01195247
Views:
66
Trying to use pessimistic table buffering to undo changes when desired.

CURSORSETPROP("Buffering", 4, 'Department') && form LOAD

..... change record

..... change another record (get error)

ThisForm.Release() && OK button

CURSORSETPROP("Buffering", 1, 'Department') && form UNLOAD

However above works OK if I change the one record only.
If I try to change more than one record I get error 2072
"Cursor cannot be modified because it contains an unsaved record."

Tried putting TableUpdate(1) but still same error.
The table is a free table and is USE AGAIN as Department
Any ideas?
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies ......... http://abri.com/
'Recover' - top rated FoxPro/dBase file repair utility.
Next
Reply
Map
View

Click here to load this message in the networking platform