Hi, The only statement concurrency currently being used is: ret = SQLSetStmtOption(m_stmt, SQL_CONCURRENCY, SQL_CONCUR_LOCK);
I would like to continue to use this as this code is in a database provider to a third party application which works with other Databases too. Is SQL_CONCUR_LOCK not supported? Is there any other workaround? Regards, Ajit -----Original Message----- From: Koetter, Thomas Theodor [mailto:thomas.theodor.koetter@;sap.com] Sent: Wednesday, October 30, 2002 1:34 PM To: ajit_cus; [EMAIL PROTECTED] Subject: RE: SQLprepare ODBC problem How did you set the SQLSetStmtAttr (SQL_ATTR_CONCURRENCY)? If you set it to SQL_CONCUR_READ_ONLY, the error should not appear, i.e. the "FOR UPDATE" will not be added to the statement. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
