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--