[sqlite] Unattended install

2013-05-25 Thread Matthijs ter Woord
Hi, I'm looking for a way to install System.Data.SQLite unattended, as part of the installation procedure of my product. How can this be achieved? Regards, Matthijs ter Woord ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Unattended install

2013-05-25 Thread Joe Mistachkin
Matthijs ter Woord wrote: > > I'm looking for a way to install System.Data.SQLite unattended, as part of > the installation procedure of my product. > How can this be achieved? > Normally, there is nothing that requires installation on an end-user machine. Simply deploy the System.Data.SQLite

[sqlite] Use more than one database in one application

2013-05-25 Thread Simon Wei
Hi, I use two databases in a application (.exe): sqlite3_open16 (“db1.db”, db_1); // open first sqlite3_open16 (“db2.db”, db_2); // open second when I INSERT some data into db_1, data is actually inserted into db_2. Is this my bug or Sqlite’s bug? Thank you. BR, Simon

Re: [sqlite] Use more than one database in one application

2013-05-25 Thread Igor Tandetnik
On 5/24/2013 8:10 AM, Simon Wei wrote: I use two databases in a application (.exe): sqlite3_open16 (“db1.db”, db_1); // open first sqlite3_open16 (“db2.db”, db_2); // open second when I INSERT some data into db_1, data is actually inserted into db_2. Is this my bug or Sqlite’s bug? I'm

Re: [sqlite] Is pragma foreign_key_check fast enough to be used in normal application flow?

2013-05-25 Thread Paolo Bolzoni
To get answers in a similar situation I found useful the EXPLAIN QUERY PLAN command. On Fri, May 24, 2013 at 3:56 PM, kyan wrote: > On Fri, May 24, 2013 at 4:46 PM, Marc L. Allen > wrote: > >> It's exhaustive in that it absolutely verifies if

Re: [sqlite] Best way to implement Find commands

2013-05-25 Thread Michael Falconer
Hi Vance, ...yes it seems reasonable to expect the same resulting order if your subsequent (temp creating) query is identical to that which was run previously. However I can understand, from a theoretical and experience point of view, why you might feel uneasy about relying on a rowid as the