Mike,
> which version of the dll are you using ?
I was using 3.2.1. I upgraded to 3.2.2 and got:
---
sqlite3explorer
---
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'.
Write of address 0133CA7D.
---
On Wed, 2005-06-22 at 16:37 -0400, Charles Hines wrote:
> Things seemed to be going rather well at first, but now quite frequently his
> app is getting the "library routine called out of sequence" error (at
> seemingly random times and places), and I have to say that I'm a little
> perplexed.
>
I
D. Richard Hipp wrote:
Please run your program in a debugger and tell
me what the subroutine "isNT()" returns in os_win.c.
If it is returning false, that would explain your
occasional inability to get a read lock on a
read-only database.
Perhaps a windows programmer can suggest a better
impl
Charles Hines wrote:
I've tried using the various PRAGMAs to help debug it (side note: the vdbe
ones don't seem to be working for me, even though I compiled with the
--enable-debug flag) as well as putting in an sqlite3 trace command that dumps
the strings being sent so I can watch how things ar
Shouldn't it be:
select name, day, distance
from (
select name as max_name,max(distance) as max_distance
from t
group by name
) as foo inner join t on t.distance = foo.max_distance and
t.name=foo.max_name
and this still returns two rows when someone has run the same distan
Howdy all.
I've recently convinced someone here who was in need of a database for his in
house Tcl/Tk application (under Solaris 8) to try SQLite (which I have been
meaning to try myself for some personal projects that have yet to be started).
I helped facilitate this by putting together a "batte
isNT() returns 1(true)
I've only seen this database lock problem while access the db file on
the (slow) NAS - local file systems seem to work fine. Even accessing
it through one of our Windows shares seems to work fine. I'll keep
you posted if I find any more information related to this problem.
which version of the dll are you using ? do you have REFERENCES
declarations ? can you send me a sample of the data ?
> -Original Message-
> From: Hugh Gibson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 22, 2005 4:22 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN: Sql
Hello Brown, Dave,
I don't receive any errors executing your SQL script with my SQLiteSpy database
explorer, which uses version 3.2.2 of the SQLite library.
Maybe you have accidentally inserted a newline into your script which
terminates the "--" comment?
Regards,
Ralf
PS: SQLiteSpy home: ht
The problem seems to be that sqlite is not recognizing
as a comment terminator (unless the comment
is alone on a line). I think you should write a bug
ticket; meanwhile, the work-around is to end your
comment with a semicolon.
sqlite> select * from t1; -- comment
...>
...> ;
a c
Just got a crash when viewing table data using SQLite3Explorer version
1.6:
---
sqlite3explorer
---
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'.
Write of address 01357AAE.
---
OK
-
Please run your program in a debugger and tell
me what the subroutine "isNT()" returns in os_win.c.
If it is returning false, that would explain your
occasional inability to get a read lock on a
read-only database.
Perhaps a windows programmer can suggest a better
implementation of the isNT() fu
Dear John,
I am using an application linked with sqlite 3.2, using a database file
which is stored in a file server and marked "read only". Sometimes
when two instances of the application (running in different PC) perform a
SELECT statement (read only) I got the same problem
The first "instance"
13 matches
Mail list logo