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

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

Postby 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
afva
 
Posts: 39
Joined: Thu 13 Aug 2009 21:22

Postby 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
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Mon 01 Feb 2010 12:31

We have corrected this behaviour. Look forward to the next build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)