[sqlite] One statement for several databases...

Hello all, Is it possible to prepare statement and use it for several databases with identical schemas? And is it possible to create statement, re-open database and then use it again for same database? -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid

[sqlite] [3.5.4] Fails importing CSV file

Hello I'm trying to import some TAB-separated records from a Windows host into a Linux host, but it fails with Error: datatype mismatch: 1. On Windows, converted file from Windows to Unix (ie. CRLF - LF) 2. On Linux, download test.csv, and ran sqlite3 db.sqlite 3. sqlite .schema CREATE TABLE

[sqlite] strange problem with DELETE

SQLite 3.5.4, Win XP, VBA with the wrapper dhRichClient Running a query like this: delete from sqlite_stat1 where not tbl in ('table1', 'table2', 'table3') The strange thing is that rows are deleted where tbl is one of the listed tables. Have tried all kind of alterations, such as making it

Re: [sqlite] strange problem with DELETE

RB Smissaert [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Running a query like this: delete from sqlite_stat1 where not tbl in ('table1', 'table2', 'table3') The strange thing is that rows are deleted where tbl is one of the listed tables. Look carefully at the values in the

Re: [sqlite] Version 3.5.5 Released

At 18:33 31/01/2008, you wrote: The big change from version 3.5.4 is that the internal virtual machine was reworked to use operands in registers rather than pulling operands from a stack. The virtual machine stack has now been removed. The removal of the VM stack will help prevent future stack

[sqlite] Duplicates in sqlite_stat1

Noticed that sqlite_stat1 can have duplicates on tbl, idx: tbl idx stat --- table1 idx190 2 1 table1 idx290 2 table1 idx12577 2 1 table1 idx22577 2 Is there any harm in this, so would SQLite know that it has to look at the last

[sqlite] Problem with encoding?

I have very simple db. Everything works ok when I use Latin letters, but when I use the Cyrillic ones - text doesn't look OK anymore. DB table structure sample: id - integer primary key inv_numb - varchar(10) not null unique name - varchar(40) not null price - float(15) HTML code is UTF-8

Re: [sqlite] [3.5.4] Fails importing CSV file

At 23:42 03/02/2008 +, Robert Wishlaw wrote: Instead of .separator \t try .separator '\t' Thanks for the tip, but I tried that too, with no success: # cat test.csv NULLTAB123-4567TABJohn Doe (Note: I just replaced 09 with TAB to show you) # sqlite3 db.sqlite SQLite version 3.5.4 Enter

Re: [sqlite] [3.5.4] Fails importing CSV file

At 02:27 04/02/2008 +0100, Gilles wrote: Thanks for the tip, but I tried that too, with no success: I tried both: sqlite .separator \t sqlite .import test.csv customer test.csv line 1: expected 3 columns of data but found 4 sqlite .separator '\t' sqlite .import test.csv customer test.csv line

[sqlite] auto index id?

Is it possible to have automatic index ID field in SQLite3?, I would like to have access to an index in my database... Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users