Error: a member that i scomputed or generated by the databas

afva · Post by **afva** » Wed 20 Jan 2010 08:42

Error: a member that is computed or generated by the database cannot be changed.

I have a master-detail table. Both have:
Auto Generated Value = true
Auto-Sync = true

I work with an Oracle database and the ID's for both tables are set in a before-insert-trigger.
This works fine, except in the following situation:
When I get an Oracle exception (for the child-record) both records are NOT inserted in the database, but the master-table DID get an ID.
So, whe I correct the error and try to submit the chages again I get the above mentioned error.

How can I avoid this?

Thanks in advance

AndreyR · Post by **AndreyR** » Wed 20 Jan 2010 15:25

Thank you for the report, we will investigate the problem.
I will let you know about the results of our investigation.

AndreyR · Post by **AndreyR** » Mon 01 Feb 2010 12:31

We have corrected this behaviour. Look forward to the next build.