>>>If there is something else failing just ask again. I browsed through the code and didn't find anything else but the CAST() I used within the SQL.
>>>
>>>Bye, Olaf.
>>
>>I think your used correlated query which is not supported in VFP 8, e.g.
>>
>>select ..., inner join (select ...)
>>
>>I'll re-check your message in tek-tips on Saturday night or on Sunday, thanks a lot again.
>yes, well, additional to that feature of (select-sql) as Alias I also used cast(). Should work fine now in VFP8. VFP7 would fail because of northwind.dbc not available, it could be done with tastrade instead.
>
>Bye, Olaf.

Thanks a lot, it works for me now. Very interesting.