Re: [sqlite] Serious Problem with .import

hi DAniel i had similar probme and at the end i had to build my own tool to migrate from csv to sql ... maybe it will solve your problem too? regards e. Цитат на писмо от Daniel de Matos Alves <[EMAIL PROTECTED]>: > PLEASE, read my e-mail, i really need help ;-) > > > I am trying to import

[sqlite] Serious Problem with .import

PLEASE, read my e-mail, i really need help ;-) I am trying to import data from a file using sqlite3 command line, and the tcl bind. But I aways get error about the Number of Columns. Sqlite always says that I am trying to put less columns than the number of columns defined in the table.

Re: [sqlite] Conversion of SQLite 3.2.5 database to 3.3.1

Robert L Cochran <[EMAIL PROTECTED]> wrote: > I have a database I created in SQLite 3.2.5, then updated with > subsequent versions up to 3.2.7. There are several tables. > > Version 3.3.1 has a new file format and I'd like to convert the database > file to this new format. How do I do that? >

[sqlite] Conversion of SQLite 3.2.5 database to 3.3.1

I have a database I created in SQLite 3.2.5, then updated with subsequent versions up to 3.2.7. There are several tables. Version 3.3.1 has a new file format and I'd like to convert the database file to this new format. How do I do that? Thanks Bob Cochran Greenbelt, Maryland, USA

[sqlite] SQLite speed tests

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 SQLite was tested in the same configuration that it appears on the website. It was compiled with -O6 optimization and with the -DNDEBUG=1 switch which disables the many "assert()" statements in the SQLite code. The -DNDEBUG=1 compiler option

Re: [sqlite] host parameter names in string literals

Darren Duncan <[EMAIL PROTECTED]> wrote: > > Alternately, and probably more elegantly, > >SELECT name FROM people WHERE name LIKE '%' || ? || '%' > Yes, it is mome elegant. Unfortunately, SQLite is stupid and does not optimize this well. It computes the concatenation once per row instead

Re: [sqlite] host parameter names in string literals

At 10:10 AM -0700 1/18/06, Robert Simpson wrote: - Original Message - From: "Marvin K. Bellamy" <[EMAIL PROTECTED]> I want to prepare a statement like this one: SELECT name FROM people WHERE name LIKE '%?%' But, it looks like host parameters inside string literals aren't parsed. Any

Re: [sqlite] host parameter names in string literals

- Original Message - From: "Marvin K. Bellamy" <[EMAIL PROTECTED]> I want to prepare a statement like this one: SELECT name FROM people WHERE name LIKE '%?%' But, it looks like host parameters inside string literals aren't parsed. Any clues as to how I pull this off or if the

Antw: [sqlite] database disk image is malformed

Hi Jan, i had a similar problem. After a long debug session i found out that the error cames from btree.c (+- line 1000) after the call get2bytes (if res > ...) return ... . so in my database i saw that there are a lot of FFŽs - anyway. here are the code snippet. btree.c

Re: [sqlite] RE: [RBL] Re: [sqlite] Randomly ordering results

On 1/18/06, Steve O'Hara <[EMAIL PROTECTED]> wrote: > if you did, then you'd notice that for regression testing, a flag is set > that forces the random() function to be seeded on the same number each > time. I hope it's a run time flag... ;) Thanks for the info.