Re: [sqlite] Retrieve INTEGER PRIMARY KEY

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 Gesen

Re: [sqlite] sqlite3.def mismatch for Windows x86 and x64 dll

2017-02-04 10:49 GMT+01:00 Rengui Xie: > Hi dear sqlite developers, > > In the downlaod page for "Precompiled Binaries for Windows", the > sqlite3.def EXPORTS for x86 and x64 dll are not the same, x64 dll have 4 > more export functions: > - sqlite3_data_directory > - sqlite3_fts5_may_be_corrupt >

Re: [sqlite] SQLite3 Pros / Cons

> On Feb 5, 2017, at 5:27 AM, Clyde Eisenbeis wrote: > > I posted "[sqlite] Retrieve INTEGER PRIMARY KEY" a few days ago. The > only solution proposed appears to use sqlite3. I think you’re confusing sqlite3 the library with its C API. You’re _already_ using the sqlite3 library, in the form o

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

http://data.sqlite.org/c3ref/last_insert_rowid.html there is an api call to get it; or you can use select and get it the .net library has it as a connection property LastInsertRowId https://www.crestron.com/reference/simpl_sharp/html/P_Crestron_SimplSharp_SQLite_SQLiteConnection_LastInsertR

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

On 5 Feb 2017, at 1:26pm, Clyde Eisenbeis wrote: > The compiler complains about "SELECT last_insert_rowid()" ... which > appears to be limited to SQLite3. The compiler should never have got that string. The string is executed when the program is already compiled, just like any other SELECT co

Re: [sqlite] SQLite3 Pros / Cons

This is good information! I posted "[sqlite] Retrieve INTEGER PRIMARY KEY" a few days ago. The only solution proposed appears to use sqlite3. On Sat, Feb 4, 2017 at 5:34 PM, Joe Mistachkin wrote: > > Random Coder wrote: >> >> And in case it's not obvious: System.Data.Sqlite _is_ sqlite3 >> > >

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

The compiler complains about "SELECT last_insert_rowid()" ... which appears to be limited to SQLite3. Perhaps I'm missing something? On Sat, Feb 4, 2017 at 10:28 AM, Wolfgang Enzinger wrote: > Am Sat, 4 Feb 2017 09:04:58 -0600 schrieb Clyde Eisenbeis: > >> When I enter last_insert_rowid(), the c

Re: [sqlite] Transactions

Michele Pradella wrote: > I have a question about transactions and SQLite: http://www.sqlite.org/faq.html#q19 Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sq

[sqlite] Transactions

Hi all, I have a question about transactions and SQLite: Do you think transactions are useful only when you have to do a sequence of statements that depends on each other and you need a way to rollback all statements if something goes wrong? or you can use transactions even with not interdependen