Chris, I have tried:
using (System.Data.SQLite.SQLiteConnection sqliteConnection = new System.Data.SQLite.SQLiteConnection("Data Source=" + stPathFilename + ";")) { using (System.Data.SQLite.SQLiteCommand sqliteCmd = sqliteConnection.CreateCommand()) { ... sqliteCmd.CommandText = "INSERT INTO ..." ... sqliteCmd.ExecuteNonQuery(); sqliteCmd.CommandText = "SELECT last_insert_rowid()"; int iKeyID = (int)sqliteCmd.ExecuteScalar(); End up with an exception: "Specified cast is not valid." Could you provide a specific example for SQLite that does work? Thanks! On Mon, Feb 6, 2017 at 9:55 AM, Chris Locke <ch...@chrisjlocke.co.uk> wrote: > Why do you say 'there is no equivalence' ? > Have you read the link I posted in the reply to your question nearly 3 days > ago? > > Last_insert_rowid() > > https://www.sqlite.org/c3ref/last_insert_rowid.html > > select @@identity and 'select last_insert_rowid()' perform the same action > - retrieving the last unique row reference. It was the answer to your > query. The link provides further research. > > > On Mon, Feb 6, 2017 at 1:19 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> In this case, there is only one record added ... no one else has >> access to this database. >> >> In the past, I have locked a record, so no one else can access that >> record while it is being modified. Is locking an option in SQLite? >> >> Perhaps there is no equivalence to OLE DB ... oledbCmd.CommandText = >> "Select @@Identity" ... int iKeyID = (int)oledbCmd.ExecuteScalar()? >> >> On Mon, Feb 6, 2017 at 1:55 AM, Hick Gunter <h...@scigames.at> wrote: >> > But only if you can guarantee that your statement inserts exactly one >> record and that nothing is executed on your connection between the insert >> and the call. >> > >> > -----Ursprüngliche Nachricht----- >> > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> Im Auftrag von Chris Locke >> > Gesendet: Freitag, 03. Februar 2017 15:41 >> > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >> > Betreff: Re: [sqlite] Retrieve INTEGER PRIMARY KEY >> > >> > Last_insert_rowid() >> > >> > https://www.sqlite.org/c3ref/last_insert_rowid.html >> > >> > On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis <cte...@gmail.com> >> wrote: >> > >> >> For OLE DB SQL, I have retrieved the primary key: >> >> >> >> ----------------------------- >> >> using (System.Data.OleDb.OleDbConnection oledbConnect = new >> >> System.Data.OleDb.OleDbConnection(stConnectString)) >> >> { >> >> using (System.Data.OleDb.OleDbCommand oledbCmd = >> >> oledbConnect.CreateCommand()) >> >> { >> >> ... >> >> oledbCmd.ExecuteNonQuery(); >> >> //Retrieve the ID >> >> oledbCmd.CommandText = "Select @@Identity"; >> >> int iKeyID = (int)oledbCmd.ExecuteScalar(); >> >> stKeyID = iKeyID.ToString(); >> >> ----------------------------- >> >> >> >> What is the correct nomenclature for SQLite? >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@mailinglists.sqlite.org >> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@mailinglists.sqlite.org >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > >> > >> > ___________________________________________ >> > Gunter Hick >> > Software Engineer >> > Scientific Games International GmbH >> > FN 157284 a, HG Wien >> > Klitschgasse 2-4, A-1130 Vienna, Austria >> > Tel: +43 1 80100 0 >> > E-Mail: h...@scigames.at >> > >> > This communication (including any attachments) is intended for the use >> of the intended recipient(s) only and may contain information that is >> confidential, privileged or legally protected. Any unauthorized use or >> dissemination of this communication is strictly prohibited. If you have >> received this communication in error, please immediately notify the sender >> by return e-mail message and delete all copies of the original >> communication. Thank you for your cooperation. >> > >> > >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@mailinglists.sqlite.org >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users