I am writing a one to many nested cdt (parentNestedChild) to the DB in one write

omere over 7 years ago

I am writing a one to many nested cdt (parentNestedChild) to the DB in one write. The cdt is created with information enter on a form so no records have an identities yet. When I write the nested cdt and save the ac!StoredValues back into the pv!; the parent and child identities are saved but the foreign key field in the child cdt which maps it to the parent is still null. The values are getting written to the database, just not being saved back. Is this expected behavior?
Thanks,

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 7 years ago

Nesting CDTs is not really recommended ... I had the same experience. Adding a script task to load the data right after the Write to DS node solved it. It looks like the DB needs a bit of time to save all relations.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 7 years ago

Nesting CDTs is not really recommended ... I had the same experience. Adding a script task to load the data right after the Write to DS node solved it. It looks like the DB needs a bit of time to save all relations.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data