Olaf, If you deliver us: -the create table of the involved tables (including all created keys, generators, a.s.o.); -some real data of the involved tables (specially for the cases when the problem happens); you will help people to help you. May be also the procedures involved in the data injection (hanging on the insert sequence, some keys - according to the structure you have) may cause to generate auto-generated keys that will bring you the data back in a not wished manner. For all of this, having some code and data may help to understand what can be causing this problems.
Cordially, Roberto Camargo. On Thursday, December 5, 2013 6:26 AM, Iwan Cahyadi Sugeng <iwan.c.sug...@gmail.com> wrote: Hi, Are you having this problem when there are more than one user in transaction at the same time i'm guessing the problem is the child table have different parent key. Check in the child table wether the parent key is correct. The problem maybe because the child get a different parent key because you might get the parent key using get last id of the parent Can you tell me how you get the parent key
