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
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01195247
Message ID:
01197416
Views:
16
Hi Paul, probable the Data Environment is overwritten your settings for the buffering, if you suspend the execution when you get the error and check the buffering of "Department" I think you will see it does not have Buffering 4, if you don't want to use the Data Evironment then assign your
Buffering in the Init event of the form.

Good luck.

>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?
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Reply
Map
View

Click here to load this message in the networking platform