It is possible the VFP ODBC driver does not support the SQL statement.

1. What version of the driver are you using?
2. What is the SQL statement?

>I have asked this before, but I have not received an answer.
>
>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.
>
>Please help,
>Mike