Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Default Buffering Mode for DataSession
Message
From
29/12/1999 13:51:18
 
 
To
29/12/1999 11:19:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00309883
Message ID:
00309989
Views:
24
>How do I programmatically set the default buffering mode for a table in a Data Session? I am talking about buffering modes 1:Off, 2:Record (Pessimistic), 3:Record (Optimistic), 4:Table (Pessimistic), or 5:Table (Optimistic). I can do it visually in the VFP development environment.
>
>When I am in the VFP 6.0 SP3 development environment, I go to the menu item Tools, choose Options..., switch to the Data tab, and in the Locking and Buffering section, change Buffering to one of the following: Off, Record (Pessimistic), Record (Optimistic), Table (Pessimistic), or Table (Optimistic).
>
>After making the Buffering change, any table that I open, using the Command window or the Data Session window, uses that buffering mode. Issuing a CursorGetProp('buffering') displays the current buffer mode (1 though 5).
>
>If I create another Data Session, I can switch between the default DS and the new DS, and independently set the default buffering mode for each DS with the Tools:Options:Data:Buffering setting.
>
>I know how to use CursorSetProp('buffering', 4) to change the value once the table is opened, but I can not figure out how to set the default buffering mode programmatically so the table opens in buffering mode 4, for example.

CURSORSETPROP("Buffering",0) will set the default for all future cursors/tables buffering mode to be 4.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform