Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlExec() returns different results
Message
 
 
To
09/07/2003 10:11:26
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00808477
Message ID:
00808478
Views:
23
This message has been marked as the solution to the initial question of the thread.
Ivan,

Make sure that Fetch data in background is unchecked/turned off.

>Hello all,
>Have a problem running SqlExec on VFP database. When using quite complex sql it gives different results. In fact, I got same number of records but it seems that inner join doesn't work same every time and joins different records without any order. e.g. on result set of 600 records I got 3 wrong joins, next time none, next time one...and so on
>
>When running same queries against dbc directly everything is ok.
>
>I reckon that ODBC driver (latest one) have a bug, or some wrong odbc settings, or....
>
>Any ideas ?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform