>Once again, VFP ODBC drive is VFP6SP5. It doesn't support anything that was added/changed in VFP after that.
Well, I did go back to not having AutoInc. This simple lack of support from Microsoft made me realize the preparation to be as close as possible to SQL Server, as far as the VFP data structure goes, was a no go. I really need to use the ODBC approach to be as generic as possible. But, now I need to find a way to have a solution for a syntax that will allow me to have a ODBC query that will be done from a cursor. As this is not possible, the last think I want to do is to query into a table first and use the full path of that table, for my INNER JOIN, thru ODBC. Is there any other alternative to achieve that? Basically, I need to group first into a query and then INNER JOIN that.