Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Buffering
Message
From
08/09/2003 13:54:15
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00827189
Message ID:
00827192
Views:
29
This message has been marked as the solution to the initial question of the thread.
>Can anyone explain to me what cursor buffering is, or point me to a good resource.

To put it very simply. VFP maintains a copy of your data in memory and does not release it to the underlying table(s) until you do a TableUpdate() or a TableRelease(). It is akin to what we used to do with Scatter Memvar/Gather Memvar back in the 2.x days.

Sure, this is a very simplified explanation, but it should give you an idea.

The VFP buffering concept is very powerful as it allows you do manipulate the data in memory before commiting your changes. It works in several modes, (record and table, optimistic and pessimistic locking).

It frees you from having to explicitly control locking (with the old RLock()/Flock() functions).

See the help file for:
CursorGetProp()
CursorSetProp()
and related functions

See also:
http://fox.wikis.com/wc.dll?Wiki~RowBuffering~VFP
http://fox.wikis.com/wc.dll?Wiki~TableBuffering~VFP
http://fox.wikis.com/wc.dll?Wiki~TransactionsAndBuffering~VFP
http://fox.wikis.com/wc.dll?Wiki~TableUpdate~VFP


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform