how to use scope_identity in sqlite

Question

I have issue when i use scop_identity in sqlite it showing the error like near "select": syntax error...i write query like this

   string txtSQLQuery = "insert into  SerpTrak_Site (SiteName) values ('" + txturl.Text +   "')select scope_identity();";

any wrong in this query please help me...

score 0 · Answer 1 · answered Apr 30 '11 at 13:46

0

Missing a semicolon between the two queries.

string txtSQLQuery = "insert into  SerpTrak_Site (SiteName) 
 values ('" + txturl.Text +   "'); select scope_identity();";

answered Apr 30 '11 at 13:46

Jeff Swensen

Hi tahnk you for giving response ..What is the correct formate i have try without semicolon also but is showing error please help me.... – Victor May 01 '11 at 08:48
1

-1 because SCOPE_IDENTITY() does not apply to SQLite databases. – Nikola Malešević Aug 11 '12 at 11:30
1

-1 because I don't think there's a SCOPE_IDENTITY() in sqlite, but now I'm not sure. – Phillip Senn Jun 07 '13 at 15:04

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

SQLite does not have a function by the name scope_identity

You are probably looking for 'SELECT last_insert_rowid()'

edited May 23 '17 at 10:24

Community

answered May 01 '11 at 08:59

Jeff

2 Answers2