Cursor Operation Conflict with Prepared UPDATE

"J. Jeff Roberts" <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
I'm trying to create a prepared statement for the following update:

  UPDATE jobhistory SET status=6 WHERE id = '3D1065E0_00001000'

The SQL I send to SQLPrepare() looks like this:

  UPDATE jobhistory SET status=? WHERE id = '?'

I bind the 6 and the '3D1065E0_00001000' to buffers of the appropriate
type, and when I call SQLExecute() I get SUCCESS_WITH_INFO and an error
of "Cursor Operation Conflict".

I've read the help about this error and it's about positioned updates
that might affect more than one row because the column in the WHERE
isn't a unique key.  The id field is NOT the primary key in this table
but it does happen to be unique and currently there is only one entry
in the table.

I tried setting SQL_ATTR_SIMULATE_CURSOR with SQLSetStmtAttr() but none
of the values I tried seemed to help.

Can anyone explain more fully what the problem might be and how to fix
it?

Thanks,
-Jeff

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.