sync master-detail at commit time [message #377857] |
Thu, 25 December 2008 23:21  |
 |
didiera
Messages: 134 Registered: August 2007 Location: Mauritius
|
Senior Member |
|
|
Merry Christmas everyone,
I unfortunately have a question for you. I have set a master-detail relation between two blocks linked by a parent-child relation (database level) on the same canvas. I have implemented commit through a save method triggered via a button. I have noticed that I get 'parent key not found' problem when saving a new record.
Test Case:
I create a new record in the master block, navigate to the detail block to feed child records for this new record(in master block) but my 'save' fails.
Test conditions:
1] The child record get its parent key copied from the master record (automated by the relation)
2] I query a temporary ID for the new master record via a select nextval from the sequence used for managing primary keys for that master block.
Hypothesis:
I guess it fails for the child records because at save time, the master record has not yet been committed (though all should happen at the same time)
Is there some means of working around this issue.
regards,
Didz
|
|
|
|
|
|
|