Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL behaviour Select versus Locate
Message
From
01/08/2013 03:34:21
 
 
To
01/08/2013 02:25:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01579633
Message ID:
01579636
Views:
49
Yes, it was the case. Thanks.

>Can it be that you are using table buffering and that that record hasn't gone through a TableUpdate() yet?
>
>Try to use the buffering clause in the select
>
>select count(*) from mytable with buffering= .t.  where seq=1234 
>
Previous
Reply
Map
View

Click here to load this message in the networking platform