List:MySQL ODBC« Previous MessageNext Message »
From:Peter Harvey Date:June 18 1999 9:54pm
Subject:Re: why INSERT fails??
View as plain text  
Federico Balbi wrote:

> Hi,
>   i just need to send from VC++ an INSERT statement to MyODBC like:
>
> SQLExecDirect(hstmt, "INSERT INTO tt VALUES (1,'Joe')");
>
> no params.. just a simple string with an INSERT statement..
>
> why do I get the following error?
>
> [Microsoft][ODBC Driver Manager] Invalid cursor state
>
> I have to use straight C code (no C++) and no CRecords...
> Somebody can tell me why ODBC cannot send this to the server??
>

Federico,

1. send complete trace
2. try SQLPrepare + SQLExecute
3. what was the error code again

Peter Harvey



Thread
why INSERT fails??Federico Balbi19 Jun
  • Re: why INSERT fails??Peter Harvey19 Jun