Data change in (insert)trigger; not able to update anymore

Data change in (insert)trigger; not able to update anymore

Postby afva » Thu 13 Aug 2009 21:42


I want to do as follows:
1. insert a record A in the database
2. perhaps update this same record.

Problem is that in Oracle I have a trigger (before insert) that truncates all of my date-fields before he puts them in the database.
That works o.k., until the customers changes record A again and wants to submit these changes to the database again.

I get th error: Row not found or changed.
I understand why this is; but I am curious to know how to avoid this.

Thanks in advance
Posts: 39
Joined: Thu 13 Aug 2009 21:22

Postby AndreyR » Fri 14 Aug 2009 12:50

Do you have the IsVersion attribute set to true for your date fields?
I think you are talking about LINQ to Oracle project, please correct me if I am wrong.
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for Oracle