>>But isn't OleDB provider supposed to work w/o any VFP runtime installed?
>
>Yes, VFP OLE DB provider has everything built into it.
>
>>So no matter what VFP is installed if you construct your query as in VFP9 it should work.
>
>And how would you test VFP9 query in VFP8?
CursorAdapter :-)
There is not big difference between VFP9 and VFP8 query, the only two that could cause errors are ORDER BY and HAVING with Fields that are not in SELECT list, other two (TOP N and GROUP BY) just gave you different results and you should check what is returned.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.