J. Jeff Roberts wrote > > 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 = '?'
? do mean a placeholder for a variable, right? But why do you surround the second placeholder with ' ' ? Then the database server will not see the placeholder, but a string with exactly one question-mark in Elke SAP Labs Berlin > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
