StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Data collision problem/question
Data collision problem/question
Post Reply
Like
0
Data collision problem/question
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
franka
franka
posted 19 Years Ago
ANSWER
Topic Details
Share Topic
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?
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Data collision problem/question
franka
-
19 Years Ago
Well, you could accomplish this in on of a couple ways:
1)...
StrataFrame Team
-
19 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search