SQLExecute fails with Invalid Cursor State...

HI,

I am trying to "reuse" a prepared statement but when I call SQLExecute, it fails on the second call.

For instance, I do this:

rc = SQLPrepare (h);
rc = SQLBindParameter (..... idstr...);
while (loop_while_changing_parameter)
{
strcpy (idstr, GetNextIDString());
rc = SQLExecute ( .... );
// rc returns -1 here but not the first time in the loop
while (rc == SQL_SUCCESS)
    SQLFetch(....);
}

Start Free Trial