The select I run inside fox, returns data... yet the same one from another application (InterSock) returns nothing..

I turned on SQL tracking and here is a snippet from that log.

InterSock fff60c2d:fff739a1 ENTER SQLFetch
HSTMT 0x008d0ba0

InterSock fff60c2d:fff739a1 EXIT SQLFetch with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 0x008d0ba0

DIAG [01S01] [Microsoft][ODBC Visual FoxPro Driver]Error in row (0)

DIAG [01004] [Microsoft][ODBC Visual FoxPro Driver]Error: Column 1 ( part ) (0)

I have used the same software to query tables in an Sybase database using the SQLAnyWhere ODBC drivers and it returns the data (or no data as the case may be) see below.

InterSock fff60c2d:fff739a1 ENTER SQLFetch
HSTMT 0x008d0ba0

InterSock fff60c2d:fff739a1 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x008d0ba0

Any ideas what is going on?


I would hate for this to be a stumbling block for the Fox.. i.e. if Fox cannot do it, I may have to switch to PowerBuilder application development. Just so I can do the above.


Also, the command takes a long time to execute.

TIA,
Mike