I have two tables with a one to many relationships. I have set buffer mode to 5 on the detail table. I want to execute code to update a field within the record that is currently updated on the insert trigger. The field will hold an unique number that I will assign as each record is updated. I am doing this since I want the number I assign to run in sequence with no gaps and the number is alphanumeric.
However, when I try to replace the field with the value I have generated i get a message that the cursor is readonly.
How can I replace the value of the current record being updated (I use Tableupdate command) before the physical update is executed without getting the readonly record?
Thanks in advance.
Stuart
Stuart Reid
True nobility lies not in being superior to another man, but in being superior to one’s previous self