How to get Record Count through ODBC

[volfreak]

We have an application that uses FoxPro tables that I need to get updates transfered to an Oracle database. I have tried SELECT CNT(*) FROM <tblname> and using SQLExecute to try and get the number of records in the Oracle table with no luck.

Can anyone help me determine, using ODBC, the number of records in our Oracle tables?

Thanks for any and all help.

 

[THoey]

If you are trying to get the count from the ORACLE tables, it is:

SELECT COUNT(*)
FROM MyTable;

If you are trying to get them from FoxPro, I am not sure, but doing it through the Oracle ODBC connection might convert it... Terry M. Hoey

 

[volfreak]

I am going through FoxPro and ODBC and tried that command with no luck. The ODBC returns -1 (indicating a failure). Guess it's time to do some more digging.

Thanks for the reply. Appreciate it.