Hi Tom,
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 15. Juni 2004 16:56 > To: [EMAIL PROTECTED] > Subject: odbc SQL_NO_DATA_FOUND on update ? > > > Hi, > > I've got a general odbc-problem with maxdb. > > what return-code should be thrown, when an update command > doesn't find any > matching record ? > > By now I supposed an odbc-driver should cause an SQL_NO_DATA_FOUND > retcode, > but my testapplication give me a SQL_SUCCESS in those cases. It should be SQL_SUCCESS_WITH_INFO. Excert from the ODBC Reference (SQLExecDirect): 01001 Cursor operation conflict *StatementText contained a positioned update or delete statement, and no rows or more than one row were updated or deleted. (For more information about updates to more than one row, see the description of the SQL_ATTR_SIMULATE_CURSOR Attribute in SQLSetStmtAttr.) (Function returns SQL_SUCCESS_WITH_INFO) Excert from the ODBC Reference (SQLRowCount): SQLRowCount returns the number of rows affected by an UPDATE, INSERT, or DELETE statement. HTH Thomas ---------------------------------------------- Dr. Thomas K�tter SAP AG, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
