Oops sorry Alessandro, I read it wrong, I thought you had doubts about creating the auto increment column. Anyway, John Craig has the answer!
Cheers On Mon, Oct 24, 2011 at 1:37 PM, John Craig <[email protected]> wrote: > Hi, Alessandro. > > put revDataFromQuery(,, gDB, "SELECT LAST_INSERT_ROWID()") into tId > > will do the trick. > > > > > On 24/10/2011 16:03, Alessandro Pisoni wrote: > >> how do I get the value of an autoincrement field in a table sqlite after I >> inserted a record with INSERT ect ect >> >> >> >> thanks >> >> >> Alessandro Pisoni >> >> >> >> >> >> >> ______________________________**_________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode> >> >> > ______________________________**_________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode> > -- http://www.andregarzia.com -- All We Do Is Code. http://fon.nu -- minimalist url shortening service. _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
