Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL not seeing all records
Message
From
08/01/2000 23:43:52
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL not seeing all records
Miscellaneous
Thread ID:
00315081
Message ID:
00315081
Views:
72
Has anyone seen this happen?
In an application..
I insert a few records into a small free table, which has one index tag.
Immediately afterward I query the table into which records are inserted in a way which should return all the just inserted records, and all are *except* the very last record inserted are returned!!
If I first "count" or "browse" the table, the subsequent query performs as expected.No buffering etc is in effect.
Looks like VFP is executing faster than the data is getting to disk in this case.

Nasty.
Next
Reply
Map
View

Click here to load this message in the networking platform