asuming I have to DB tables:
a) <b>CUSTOMER</b> with fields
b) <b>CONTRACT</b> with fields
The IDs of both tables (<b>CUSTOMER</b>, <b>CONTRACT</b>) are generated by the DB.
So the INSERT for the CUSTOMER Table would be
<i>INSERT INTO CUSTOMER (NAME) VALUES ('CLONEY')</i>
For the second insert into the CONTRACT table, I need the CUSTOMER_ID from the first insert. How can I do that in XI?
Thanks a lot, Regards Mario