get value autoincrement into db sqlite

[John Craig]

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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>