I am using VB to interface with my VFP database, using ODBC. I am using DAO
I can setup the connection to the database successfully, I can query it
successfully, I can even update/delete records from the table. But I am
unable to insert into the table. My table has several fields but none of
them HAVE to be filled up. e.g.
When I pass the command
qry="INSERT INTO SOILTIN (ID) VALUES (8);"
I get the error - 3146 - ODBC call failed.
When I run the same command from the VFP command window it excutes
Can anyone please tell me what I am doing wrong???