Re: [sqlite] How to use "cursors" in c#

ent: Tuesday, 28 June, 2016 11:59 > To: SQLite mailing list > Subject: Re: [sqlite] How to use "cursors" in c# > > > On 28 Jun 2016, at 4:56pm, R Smith <rsm...@rsweb.co.za> wrote: > > > I am not clear on what happens for INSERT OR REPLACE re

Re: [sqlite] How to use "cursors" in c#

> ... If your application requires concurrent network access, you should be > using either a network client/server DBMS or programming your own > Client/Server pair with the server process calling the SQLite API to modify > the db file held on the servers' local filesystem. ... There is an

Re: [sqlite] How to use "cursors" in c#

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of R Smith > > As an aside - I've always prescribed generating your own ID's. There is no > requirement for using AUTOINCREMENT in any DB - It's a

Re: [sqlite] How to use "cursors" in c#

On 28 Jun 2016, at 4:56pm, R Smith wrote: > I am not clear on what happens for INSERT OR REPLACE results when a row gets > updated in stead of inserted, but the documentation should have details. In SQLite, the REPLACE operation really does delete the original and insert a

Re: [sqlite] How to use "cursors" in c#

On 2016/06/28 5:10 PM, Drago, William @ CSG - NARDA-MITEQ wrote: Ah, good thoughts. My thinking was that the last row id wouldn't be valid until the transaction was successful. But I guess if the transaction is not successful it doesn't matter what the last row is because now there are

Re: [sqlite] How to use "cursors" in c#

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of R Smith > Sent: Tuesday, June 28, 2016 7:33 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] How to

Re: [sqlite] How to use "cursors" in c#

On 2016/06/28 12:17 PM, William Drago wrote: I am programming in c# and I have to insert into a .sqlite file a new row and get back the id of this last inserted row. This file "unfortunately" might be located on an internal network and other users might try to add other rows in the

Re: [sqlite] How to use "cursors" in c#

I am programming in c# and I have to insert into a .sqlite file a new row and get back the id of this last inserted row. This file "unfortunately" might be located on an internal network and other users might try to add other rows in the meantime. I can't help with your locking issues, but

Re: [sqlite] How to use "cursors" in c#

As another further response and if you use automatic INTEGER PRIMARY KEY IDs, then the sqlite3_last_insert_rowid() call will tell you unambiguously, provided the call is made within an explicit transaction initiated before the insert. As a further response, regarding that Martina said "insert

Re: [sqlite] How to use "cursors" in c#

te.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Martina Pasini Gesendet: Montag, 27. Juni 2016 20:51 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] How to use "cursors" in c# Hello to Everyone! I am sorry to bother you, but I am new to DB and S

Re: [sqlite] How to use "cursors" in c#

on. Gunter -Ursprüngliche Nachricht- Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Martina Pasini Gesendet: Montag, 27. Juni 2016 20:51 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] How to use "curso

[sqlite] How to use "cursors" in c#

Hello to Everyone! I am sorry to bother you, but I am new to DB and SQLite and I have a doubt. I am programming in c# and I have to insert into a .sqlite file a new row and get back the id of this last inserted row. This file "unfortunately" might be located on an internal network and other