> I want to insert a parent record and a bunch of children (the children
> are going into a few tables). How can I get the uniqueid back from the
> stored procedure, so that:
>
> 1) the children can have the right uniqueid form the parent; and
> 2) I know what record I just added?
>
> What I'm thinking of here is something like an invoice number that is a
> system defined visible key.
you probably use record buffering for the parent and table buffering for
the chiled records
you can set a predefined (in the SP for example) dummy number for the
parent
and chield records
then use triggers (update) and RI (refrential integrity) builder to make
the update in the parent's ID bubble to the chield ones
Arnon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only