Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What the (bleep) is wrong?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00196785
Message ID:
00196828
Vues:
39
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform