Page 1 of 1

get automatic increment id from query

Posted: Fri Oct 10, 2003 6:36 am
by yaron
Hello all,
I have an insert query which one of the fields is id (automatic increment)
is there a way to know what is the value that was inserted to the id after I execute the query or I have to make another query just after that in order to get the value that was inserted?
Thanks

Posted: Fri Oct 10, 2003 6:38 am
by twigletmac

Posted: Fri Oct 10, 2003 6:50 am
by yaron
thanks :-)