[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
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 1: expected 3 columns of data but found 1 Gilles. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 NULL123-4567John Doe (Note: I just replaced 09 with to show you) # sqlite3 db.sqlite SQLite version 3.5.4 Enter ".help" for instructions sqlite> .schema CREATE TABLE customer (id INTEGER PRIMARY KEY AUTOINCREMENT, tel VARCHAR(32), name VARCHAR(255)); CREATE INDEX index_tel ON customer (tel); sqlite> .separator '\t' sqlite> .import test.csv customer test.csv line 1: expected 3 columns of data but found 1 Gilles. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 formated and has proper meta tags... Any idea how to solve this problem of mine? -- Best regards, Vladimir Mincev ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 added stats? RBS ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 overflow bugs and will also facilitate new optimizations >in future releases. > >There should be no user-visible changes to the operation of SQLite >in this release, except that the output of EXPLAIN looks different. > >In order to make this change, about 8.5% of the core SQLite code >had to be reworked. We thought this might introduce instability. >But we have done two weeks of intensive testing, during which time >we have increased the statement test coverage to 99% and during >which we have found and fixed lots of minor bugs (mostly things >like leaking memory following a malloc failure). But for all of >that testing, we have not detected a single bug in the new >register-based VM. And for that reason, we believe the new >VM, and hence version 3.5.5, is stable and ready for production >use. The new VM was designed with a possible (low probable) port to VHDL/Verilog for Sqlite in FPGA? Changing from a VM stack to VM register based make easier to port. Perhaps it's a very crazy idea... One reason that life is complex is that it has a real part and an imaginary part -Andrew Koenig ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 rows that you believe are being deleted inappropriately. Perhaps the value is not precisely 'table1'; for example, may it be that it has trailing spaces, as in 'table1 ', and you just don't notice it when eyeballing the rows? Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 case-insensitive, leaving off single quotes or doing instead double-quotes, but I always get deletes that should not happen. Must be overlooking something simple here, but can't see it and thanks for any advice. RBS ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 customer (id INTEGER PRIMARY KEY AUTOINCREMENT, tel VARCHAR(32), name VARCHAR(255)); CREATE INDEX index_tel ON customer (tel); sqlite> .separator "\t" sqlite> .import test.csv customer Error: datatype mismatch I've tried the following formats, to no avail: NULL\t123-1234\tJohn Doe\n \t123-1234\tJohn Doe\n Any idea why SQLite fails importing this type of records? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users