Re: [sqlite] case (in)sensitiveness in LIKE operator v2 and 3

2004-07-19 Thread Daniel K
--- Alexander Mardirossian <[EMAIL PROTECTED]> wrote: > Thank you Daniel, > > That will help. > > Do you know if it is planned that the lookup tables > are planned to be added > any soon to the source at least as an option to have > the sqlite compiled > with them. > > BTW are you aware if

Re: [sqlite] Another way of corrupting the database.

2004-07-19 Thread Randall Fox
Is there any way to determine the sqlite version either before opening the database, or immediately after? For example, if I update my application to v3.x, I would like to detect when a user tries to open a v2.x database, and then perhaps convert it to the new v3 compatible format. Off the top

[sqlite] Improved Interpreter in latest SQLite version?

2004-07-19 Thread gohaku
Hello everyone, I am currently using SQLite v2.8.11. I have not had much experience with SQLite other than executing simple Queries and Updates. I don't have any problems with SQLite v2.8.11 and as such, have not upgraded to v3.0.2 I would like to know if v3.0.2 has an improved interpreter. Below

Re: [sqlite] SQLITE DLL with TCL Bindings tclsqlite-2_8_14.zip does not contain the right files

2004-07-19 Thread Lawrence Chitty
- Original Message - From: "Schurack, Harald" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 19, 2004 7:51 AM Subject: [sqlite] SQLITE DLL with TCL Bindings tclsqlite-2_8_14.zip does not contain the right files > Hello SQLITE users > i downloaded the current version of

Re: [sqlite] assert failure in btree.c

2004-07-19 Thread D. Richard Hipp
Dave Chandler wrote: > I am getting an assert failure in btree.c, in the method: static void > insertCell(Btree *pBt, MemPage *pPage, int i, Cell *pCell, int sz) at line > 2055: assert( sz==cellSize(pBt, pCell) ) > > I am running version 2.8.13 on vxWorks. I have been able to successfully run >

Re: [sqlite] cross compile under cygwin for an ARM target

2004-07-19 Thread Doug Currie
Monday, July 19, 2004, 1:41:27 PM, Jeff Dever wrote: > I'm running cygwin on WindowsXP and need to compile a sqlite library for > use with our ARM embedded system which uses the eCOS. I have the 3.0.2 > sources to build from and am using the command: > configure --host=arm > After running

[sqlite] Data Types

2004-07-19 Thread Drew, Stephen
Hi there,   I am using the PRAGMA command "SHOW_DATATYPES=on".  However, not all of my queries return the datatypes.  Has anyone else experienced this problem?   Regards,Steve

[sqlite] assert failure in btree.c

2004-07-19 Thread Dave Chandler
I am getting an assert failure in btree.c, in the method: static void insertCell(Btree *pBt, MemPage *pPage, int i, Cell *pCell, int sz) at line 2055: assert( sz==cellSize(pBt, pCell) ) I am running version 2.8.13 on vxWorks. I have been able to successfully run some simple canned data tests

[sqlite] Can you set admin password on a SQLite database

2004-07-19 Thread Richard Kure
I need to set an admin password on a SQLite database, so it's only accessible if you have that password, is that possile?? Richard _ På udkig efter en ny bolig? http://www.msn.dk/house

[sqlite] Can you set admin password on a SQLite database

2004-07-19 Thread Richard Kure
I need to set an admin password on a SQLite database, so it's only accessible if you have that password, is that possile?? Richard _ Find din nye bil billigst http://biler.msn.dk/

[sqlite] sqlite-3.0.2.so.gz

2004-07-19 Thread Corwin Burgess
When I try to extract the precompiled shared-library for Linux sqlite-3.0.2.so.gz I get a 'No files in current archive' error. I've tried to download it several times and all I get is 53 bytes. The previous version downloads and extracts ok. Corwin

[sqlite] SQLITE DLL with TCL Bindings tclsqlite-2_8_14.zip does not contain the right files

2004-07-19 Thread Schurack, Harald
Hello SQLITE users i downloaded the current version of the tcl bindings for Sqlite as stored in the download section of http://www.sqlite.org/download.html Windows binaries: tclsqlite-2_8_14.zip (115144 bytes) Bindings for TCL. When i extacted the files i found that the archive contains the

[sqlite] Another way of corrupting the database.

2004-07-19 Thread George Ionescu
Hello SQLite users, Hello Dr. Hipp, I think I have found another way to corrupt an sqlite database: create it with v3.0.2, add some data, open it with v2.8.14 and then try to open it back with v3.0.2. Regards, George Ionescu