Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL not seeing all records
Message
From
11/01/2000 20:22:00
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00315081
Message ID:
00316612
Views:
30
>>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.
>
>If you move the record point off of the newly inserted record, does this help?

Yes it does. That's my work around. But I am worried about where else I might be getting stung.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform