Very Computer

Hi,

I am using VB to interface with my VFP database, using ODBC. I am using DAO
3.5.

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);"
odbc.execute qry

I get the error - 3146 - ODBC call failed.

When I run the same command from the VFP command window it excutes
successfully.

Can anyone please tell me what I am doing wrong???

Thanks
Kiran

Is that all the error you get back? Ouch.
Can you hit the Errors collection to see if there's more info?

Is there a primary or candidate key on that field, so that 8 is already in
there for ID?
Does every insert fail?

I don't know how DAO works, so I'll ask -- is the ";" required at the end,
or does it pass the SQL command as-is to the database?
If it passes it through as-is, the ";" may give a problem, since it's the
line continuation symbol in VFP.
If not, then ignore what I just said < g >

--
Please respond to the newsgroup so that all may benefit from the discussion.

Quote:> Hi,

> I am using VB to interface with my VFP database, using ODBC. I am using
DAO
> 3.5.

> 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);"
> odbc.execute qry

> I get the error - 3146 - ODBC call failed.

> When I run the same command from the VFP command window it excutes
> successfully.

> Can anyone please tell me what I am doing wrong???

> Thanks
> Kiran