Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select with buffering = .t.
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01349615
Message ID:
01349983
Views:
23
Hi Russell,

> I'd not heard that row buffering was done in a kludgey way.

Not "kludgey". ;-) Row buffering is implemented on top of table buffering. If you enable buffering, VFP uses table buffering for all four modes. With row buffering VFP uses additional code to commit changes when you move the record pointer. In addition, some functions such as GETNEXTMODIFIED() and commands like INDEX ON check this flag.

Because row buffering happens in addition to table buffering code, you have the various strange effects such as record getting updated even if you don't move the record pointer, or row-buffered tables with multiple uncommitted records.
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform