History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: NEO-65
Type: Wish Wish
Status: Closed Closed
Resolution: Won't Fix
Priority: Minor Minor
Assignee: Erik Doernenburg
Reporter: Casper
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Neo

Possibility of using triggers

Created: 11/Oct/06 07:26 AM   Updated: 12/Oct/06 06:52 AM
Component/s: None
Affects Version/s: 1.3.2
Fix Version/s: None

Time Tracking:
Not Specified

Environment: Windows XP/SQL2005


 Description  « Hide
On our database we are currently replicating some of our tables using triggers, it seems that whenever a CRUD operation is called, on one of the replicated tables the "cmd.ExecuteNonQuery() in DbDataStore.ExecuteNonQuery" returns rowsaffected = 2, one for the actual update, and one for the trigger update.
(by the way i didn't setup the replication, I just bound to use it that way)

The result is obviosly that the optimistic locking fails, since it always test for rowsaffected=1, so...

The wish from my perspective would be that we somhow could specify expected rowcount on table level, Don't know if this is to far out (or is already solved, somhow, u'r version = 1.3.2), but i have to try, since it's possible that I'm not the only one facing this problem.

Br Casper



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Erik Doernenburg - 12/Oct/06 06:49 AM
Setting SET NOCOUNT ON in your trigger fixes that.