For any columns that you do not specify, ODBC will attempt to place NULLs into those columns. You need to turn null support on for each field. Or, you need to specify some default values for those columns...


>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