Re: [sqlite] Can't load sqlite 3.75 under tcl 8.4.4.0

2011-04-12 Thread mweiguo
于 2011-4-10 12:43, thoselai...@shaw.ca 写道: > % package require sqlite > couldn't load library "C:/Tcl/lib/sqlite3/sqlite3/.dll": this library or a > dependent library could not be found in library path > > What is sqlite3/.dll ? > Where did that "/" come from? > > The pkgindex file contains - > >

[sqlite] Disable lock controls on Windows

2011-04-12 Thread Marco Turco
Hi all, As I remember it is possible to disable the Sqlite locking method in the Unix compiled lib but is it possible also to disable the locking in the Windows compiled lib of Sqlite ? There are locking problems in some "exotic" hardware configuration for which I should manage the locking

[sqlite] Corruption on many Windows XP hosts

2011-04-12 Thread James Green
We have an application that we distribute to our clients each of whom run Windows - often it's a desktop XP machine. Our app consists of a set of Delphi services and a PHP web front end each of which use ODBC for database connectivity. The vast majority of installations have shipped with

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-12 Thread Simon Slavin
On 12 Apr 2011, at 10:15am, James Green wrote: > We recently began shipping a third component - a Java app which again > connected by ODBC. However, it used threads and the database fell over > inside of hours. We found and fixed mulitple thread safety issues and > the rate of corruption reduced

[sqlite] Sorting Question

2011-04-12 Thread caurues
I am hoping I can get an answer to my question. I want to sort a column in ascending order, but I want null values to sort to the bottom. A simple ORDER BY ColumnA ASC sorts the column in ascending order with null vales appearing on top. The following code, however, works correctly, but I have no

Re: [sqlite] Sorting Question

2011-04-12 Thread Igor Tandetnik
caurues wrote: > I am hoping I can get an answer to my question. I want to sort a column in > ascending order, but I want null values to sort to the bottom. A simple > ORDER BY ColumnA ASC sorts the column in ascending order with null vales > appearing on top. The following

[sqlite] SQLite version 3.7.6

2011-04-12 Thread D . Richard Hipp
SQLite version 3.7.6 is not available from the website: http://www.sqlite.org/ Version 3.7.6 is a regularly scheduled bi-monthly maintenance release. Updating from version 3.7.5 is optional. Updating from versions prior to 3.7.5 is recommended. A summary of changes in SQLite version 3.7.6

Re: [sqlite] SQLite version 3.7.6

2011-04-12 Thread Oliver Peters
writes: > > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ [...] really not ;-) ? Please don't disappoint your followers. greetings Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Problem setting journal_mode=WAL

2011-04-12 Thread Jaco Breitenbach
Dear experts, My application makes use of several data files attached to the SQLite database. Data files are attached on demand as they become necessary. I'm experimenting with the WAL journalling mode as a speed/performance optimisation. Unfortunately I'm having some difficulty setting the

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-12 Thread James Green
On 12 April 2011 11:27, Simon Slavin wrote: > > On 12 Apr 2011, at 10:15am, James Green wrote: [ ... ] > Was it built threadsafe ?  See > > http://www.sqlite.org/threadsafe.html Apparently so - the odbc drivers use -DTHREADSAFE=1 when building sqlite. [ ... ] > You don't

Re: [sqlite] SQLite version 3.7.6

2011-04-12 Thread D . Richard Hipp
On Apr 12, 2011, at 8:49 AM, D. Richard Hipp wrote: > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ The "not" in the sentence above should be "now", of course. Sorry for the typo. > > Version 3.7.6 is a regularly scheduled bi-monthly maintenance release.

Re: [sqlite] Problem setting journal_mode=WAL

2011-04-12 Thread Pavel Ivanov
> If the 'COMMIT' reports that no transaction is active, why is the > JOURNAL_MODE pragma still complaining about it being within a transaction? > Am I missing something here? Probably you have some not finalized SELECT statements still active. To check that you can call sqlite3_close - it will

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-12 Thread James Green
Incidentally running pragma integrity_check on one of the samples I have been given returns: *** in database main *** On tree page 1824 cell 0: invalid page number 218103808 On page 73608 at right child: 2nd reference to page 92497 Page 92110 is never used Page 92494 is never used Page 92496 is

Re: [sqlite] completion of sql words

2011-04-12 Thread Sylvain Pointeau
Hello, I just tried APSW on max os x, but how to get the auto-completion to work? it does not work for me... Best regards, Sylvain On Sat, Apr 9, 2011 at 11:50 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/09/2011 02:03 PM, Edzard

Re: [sqlite] completion of sql words

2011-04-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/12/2011 11:16 AM, Sylvain Pointeau wrote: > I just tried APSW on max os x, > but how to get the auto-completion to work? > it does not work for me... It requires the Python readline module to work as that is what lets you edit the command line

Re: [sqlite] Sorting Question

2011-04-12 Thread caurues
Thank you Igor! Now I understand. Caureus Igor Tandetnik wrote: > > caurues wrote: >> I am hoping I can get an answer to my question. I want to sort a column >> in >> ascending order, but I want null values to sort to the bottom. A simple >> ORDER BY ColumnA ASC sorts

[sqlite] Help with error codes

2011-04-12 Thread jeff archer
I have a process which analyzes an image then writes results to database.  (sqlite 3.7.4) When I run multiple of these in parallel, each on its own image but all on the same database, and all on same machine (Windows 7) I get an error from sqlite3_step() when attempting to execute "BEGIN

Re: [sqlite] Help with error codes

2011-04-12 Thread Richard Hipp
On Tue, Apr 12, 2011 at 6:06 PM, jeff archer wrote: > I have a process which analyzes an image then writes results to database. > (sqlite 3.7.4) > When I run multiple of these in parallel, each on its own image but all on > the > same database, and all on same machine

[sqlite] FTS4 compress/uncompress functions

2011-04-12 Thread Alexey Pechnikov
Which functions will be correct? As example, affinity for uncompress functions can be as "blob" as "text". Now this is not important but some tests will be nice for future compability. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___

Re: [sqlite] Help with error codes

2011-04-12 Thread jeff archer
>drh   Tue Apr 12 22:23:38 GMT 2011 > >Set your breakpoint on the function winAccess if you want to try to debug >this. If only it were that easy.  Its intermittent and attaching a debugger seems to mask the problem.  It's never been seen with only a single process and occurs more when there

Re: [sqlite] FTS4 compress/uncompress functions

2011-04-12 Thread Dan Kennedy
On 04/13/2011 06:22 AM, Alexey Pechnikov wrote: > Which functions will be correct? As example, affinity for uncompress > functions can be as "blob" as "text". Now this is not important but > some tests will be nice for future compability. You mean what type of value should compress() return? Any