How would it be possible if you need to get a new key first? In the SQL World we use cascading updates or triggers and we use transactions to ensure all updates are processed. If you can generate a primary key manually then you could run both updates not worrying to have orphan records. Is this your concern?
--- In [email protected], "johndoematrix" <johndoemat...@...> wrote: > > can that be done in one process and if possible how? >

