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:
01349989
Views:
22
Hi Russell,

> This feature is not working like it seems it should be working.

It seems that field validation rules in general are evaluated:
Set Multilocks on
Create cursor test (f c(10) check not Empty(f))
CursorSetProp("Buffering",5)
Append Blank
Select * from Test with (buffering = .T.) 
However, those behave like row buffered records, that is, moving of the record pointer validates the record even with table buffering. Indexes seem to behave like a combination. Normally they are only evaluated when you commit changes, but SELECT seems to force an update on the indexes and thereby raise this error message.
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform