Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What the (bleep) is wrong?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00196785
Message ID:
00196828
Views:
32
>I use table buffering with a value of 5 for optimistic table lock.
>When I'm done, I use a value of 1 to disable table buffering.
>
>It always used to work, but now I get an error when I disable table buffering that says that table buffering is not enabled.
>
>Can USE .... IN 0 SHARED
>or
>SET EXCLUSIVE OFF
>
>bother table buffering? I can't think of anything else that I have changed. I use table buffering in Edit mode and Add mode and Delete mode. So when I go into Edit mode I am enabling table buffering and then when I do a save I am disabling table buffering after the TABLEUPDATE (.T.) command.

Not sure why you need to turn buffering off once you are finished updating the table. The only way to change buffering is with CursorSetProp("Buffering", nExpr, "MyTable_or_MyView") where nExpr is anwhere from 1 to 5. You need to check if a table is buffered before disabling it:
If CursorGetProp("Buffering", "MyTable") > 1
   = CursorSetProp("Buffering", 1, "MyTable")
endif
You of course have to have SET EXCLUSIVE OFF and SET MULTILOCKS ON for buffering. You may not disable buffering on views. Views have either Optimistic record or file buffering.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform