Hi,
When I SET NOCOUNT ON before applying updates I get the message 'record not found or changed by another user'. When I not issue this statement everything works fine. Is this a limitation of dbxpress ?
When SET NOCOUNT is ON, the count of rows affected by a SQL statement is not returned.
dbExpress raises exception 'Record not found or changed by another user' when RowsAffected < 1.
Set option NOCOUNT to OFF.