Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Default Buffering Mode for DataSession
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00309883
Message ID:
00310009
Views:
25
>>>>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.
>>
>>That command gives an error.
>
>Whoops, that's because it's not right! ;)
>
>It should be CURSORSETPROP("Buffering",4,0).
>
>Sorry about that. :(

This must be an undocumented feature. The second parameter of 4 is pessimistic buffering, and the 3rd parameter is usually a view or table name [if passed]. I just tried this on a remote view [where only optimistic buffering is permitted], and it worked.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform