[serogole]

I am sure this has been done many times: I have an auto increment key field, say order_No, and on inserting an order I need to know the value of order_no so I can insert order lines linked to the order. How do I retrieve this value? I am already thinking about work-arounds like keeping the numbers in a separate table.
Best Regards

[ss659]

Originally posted by serogole
I am sure this has been done many times: I have an auto increment key field, say order_No, and on inserting an order I need to know the value of order_no so I can insert order lines linked to the order. How do I retrieve this value? I am already thinking about work-arounds like keeping the numbers in a separate table.
Best Regards

Select seq_name.currval
from dual;

[serogole]

Thanks, I got it - www.mysql.com/ articles/autoincrement-with-connectorj.html
Best Regards

Originally posted by ss659
Select seq_name.currval
from dual;