SA-MP Forums Archive
sqlite insert id - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: sqlite insert id (/showthread.php?tid=475946)



sqlite insert id - Kwashiorkor - 15.11.2013

i am looking for the sqlite counterpart of https://sampwiki.blast.hk/wiki/MySQL#mysql_insert_id is there anything like that available?


Re: sqlite insert id - MCZOFT - 15.11.2013

explain more dude , really i dident get what you need


Re: sqlite insert id - Jefff - 15.11.2013

last_insert_rowid() or SELECT MAX(ID) FROM TABLE
then get field and add + 1


AW: Re: sqlite insert id - Kwashiorkor - 15.11.2013

Quote:
Originally Posted by MCZOFT
View Post
explain more dude , really i dident get what you need
have you even read the wiki article? explains everything
Quote:
Originally Posted by Jefff
View Post
last_insert_rowid()
the function is not defined, neither in a_sampdb.inc nor in any other includes