In Delphi 6 I have an ADO connection to a Visual Foxpro table that I can open and add records to with no problem. I am attempting to query the table with the sql statement:
SELECT ALL sProjSpec, cModName, dCheckIn;
ORDER by sProjSpec, cModName;
GROUP by sProjSpec, cModName
in a TADOQuery object. I get the message "[Microsoft][ODBC Visual Foxpro Drive]Command is missing a required clause." when I attempt to make it active. From the command window in Visual Foxpro 6 that command works fine. I'm scratching my head here. There is no required clause missing as far as I can see. Help!