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 ?