Hi there,
I must be confusing my syntax somehow, because I'm having trouble doing a
simple update with returned id... As in.... I have two tables: an order
table and an orderitems table. I need to write the order record, then use
the order_id from the order record in the insert to the orderitems record.
1. Can I use a transaction begin/end for the entire transaction if I need
to get the order_id in between the two writes?
2. How do I get the order_id from the record I just wrote?
thanks in advance.
-sj