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
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
> 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
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
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
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:
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
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
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
9 matches
Mail list logo