Hello, If someone could be so nice and help me with that. I use SAP DB for more than year, now I have 7.3.0.30 on Linux. I write DB_PROC which is dedicated to delete some unuseful rows in my tables. In my procedure I always try to handle errors by using TRY / CATCH sections. Maybe my impression is wrong, but I've noticed that whenever I use DELETE statement with search conditions i.e. DELETE "TBL_OWNER"."TBL_NAME" WHERE FIELD_NAME='VALUE' inside my procedure and no row is found the procedure ends it's work, even without jumping to CATCH section . In documentation concerning DELETE statement we can read: a.. If no row is found that satisfies the conditions defined by the optional clauses, the following message appears: 100 row not found . But in my case no error is raised. Of course - there is a workaround with using SELECT COUNT statement, but the performance would be much worse. Could someone give me any hint how to change this behaviour or confirm if this is a bug ?
Thanx in advance, Marcin Pytel _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
