Once again, VFP ODBC drive is VFP6SP5. It doesn't support anything that was added/changed in VFP after that.


>This select works well in VFP mode:
>
>

>IF NOT loDMA.SQLExec('SELECT Country.Numero,Country.'+gcReturnTitle+' AS Title,Temp.SchoolTotal FROM '+;
> '(SELECT School.NoCountry,COUNT(*) AS SchoolTotal FROM School WHERE School.Status=2 GROUP BY 1) Temp '+;
> 'INNER JOIN Country ON Temp.NoCountry=Country.Numero '+;
> 'ORDER BY 2')
>   RETURN loDMA.cHtml
>ENDIF
>

>
>But, doing this same sub select in ODBC, generates a result of -1. There seems to be some incompability in the syntax in this SQL. Anyone would know how I can adjust to have something generic?