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 is UNIQUE and currently there is only one entry in the table, so I don't understand the error. 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
