#7 mysql_insert_id() usage

[Anonymous]

How can I get the result form the

mysql_insert_id()

function with Rexxsql?

Last_insert_id won't do me for my current application,
I need to store this value for future use.

Thanks
Miles

[Mark Hessling]

Logged In: YES
user_id=86185

Why wouldn't:
/**/
Call sqlcommand 'q1', 'select last_insert_id() as lid'
Say q1.lid.1
do what you want ? q1.lid.1 has the last value of the
auto_increment column.