get value autoincrement into db sqlite

[Andre Garzia]

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 <john at splash21.com> 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
>> 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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>>
>>
> ______________________________**_________________
> 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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>



-- 
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.