Data collision problem/question


Author
Message
franka
franka
StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)
Group: Forum Members
Posts: 22, Visits: 35
I have a table that contains 2 columns, updated_on and updated_by, that are updated by an update trigger in the database (SQLServer 2005).  The BO's fill method uses a simple "SELECT * FROM TABLE" statement.  Whenever I update a particular row more than once using the same instance of the BO, I get a data collision on the updated_on column.  Since the user doesn't directly update the updated_on/by columns I changed the SELECT statement in the BO not to return them.  The data collision problem has now gone away.

Should I keep columns updated by triggers out of updateable BOs?

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search