>Jayesh,
>
>I am able to connect to the Paradox table using SQLCONNECT.
>now I was triing to perform the following command with no results.
>sqlexe(gnConnHandle,'select * from customer where customer__="1001"', 'newdata')
>
>What might I be doing wrong?
>
>Thanks James

Hi James,

I couldn't see any grammer mistake except the name of the table 'Customer__'.
If this is not the problem then try to find out the exact ODBC error using

?sqlexe(gnConnHandle,'select * from customer where customer__="1001"', 'newdata')
?AERROR(latemp)
DISP MEMO LIKE latemp

See what error you are getting in latemp.


Bye
Jayesh