i have a table which has an ID column defined as INTEGER PRIMARY KEY. I'd like to know the value of the automatically generated ID right after the insert. is there anyway to get the ID without issuing another select? does the insert function return the ID in any way? if another select is necessary, what is the best way to do it? this is kind of a generic problem so i am hoping whoever solved this issue before could share some thoughts. Thanks for the help.
jack.