Hi John,

Now i am facing another problem in INSERT INTO command.
my command is like,

=sqlcon....
....
....
mysql = "Insert into A (Company) Values ('A')"
ReturnString = sqlexec(conn_number,MySql)

A is my Foxpro Table. and i connected Fox Databse through ODBC.
it added records in table A. but it returns ReturnString as -1.
i tried with many INSERT INTO commands, but not success. it updates database but wrongly returns the result in ReturnString.

waiting for your reply

regards
amit