Hello,
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