Hello. My problem is as follows:
1) I have a MultiSQL data object that inserts a record with
a computed row. This computed row generates a unique
ID using NEXTVAL - this ID is the primary key of the table.
2) After the insert, I would like to use the value of that
computed ID for other data objects, since that ID field
is a foreign key in other tables. That is, I could use that
ID as a dynamic criterion with other inserts.
So, is there a way I can retrieve the value of this
computed column (i.e. a getLastResults() for an Insert)
*without* re-executing the MultiSQL data object as a Select,
and getting the value that way? I am afraid of taking the
performance hit.
TIA,
John G. de Freitas
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
