于 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 -
package
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 method
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
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
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
caurues caureu...@aol.com 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 code,
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
D.Richard 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
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
On 12 April 2011 11:27, Simon Slavin slav...@bigfraud.org 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 mention
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.
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 fail
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
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 rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/09/2011 02:03 PM, Edzard Pasma
-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 and
Thank you Igor! Now I understand.
Caureus
Igor Tandetnik wrote:
caurues caureu...@aol.com 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
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
On Tue, Apr 12, 2011 at 6:06 PM, jeff archer jarch...@yahoo.com 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 (Windows 7) I
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/
___
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 are
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 type.
21 matches
Mail list logo