Re: [sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)

2008-03-08 Thread Zbigniew Baniewski
On Sun, Mar 09, 2008 at 01:41:24AM +, [EMAIL PROTECTED] wrote: > The error is not occurring until later, the first time you > try to access the database using the dbcomm object. Yes, right - opening itself isn't any access yet. -- pozdrawiam / regards

Re: [sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)

2008-03-08 Thread drh
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > I'm afraid, I've discovered a bug: there's no possibility to "catch" the > error "database is locked". Even, when one's trying something like: > > #v+ > if { [catch {sqlite3 dbcomm $fullPathToDatabaseFile} err] } { > puts $err > } > #v- > >

[sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)

2008-03-08 Thread Zbigniew Baniewski
I'm afraid, I've discovered a bug: there's no possibility to "catch" the error "database is locked". Even, when one's trying something like: #v+ if { [catch {sqlite3 dbcomm $fullPathToDatabaseFile} err] } { puts $err } #v- There'll be no $err output, because - as it seems - "catch" won't

Re: [sqlite] [C] Linker Error

2008-03-08 Thread Severin Müller
Hi Folks Thanks for your answers. I already had the latest build, and i linked the lib correctly with my Linker. I found the solution in the meantime. It was quite easy actually: I only had to manually add the -ldl option to my linker and all worked fine. Thanks anyway for your support :)

Re: [sqlite] [C] Linker Error

2008-03-08 Thread John Stanton
Looks like you need to include the shared library archive into your LIB list. Severin Müller wrote: > Hi folks > > I tried to include sqlite3 in my current C Project. > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. > Then, i downloaded the sqlite source and

Re: [sqlite] [C] Linker Error

2008-03-08 Thread drh
Clay Dowling <[EMAIL PROTECTED]> wrote: > Severin Müller wrote: > > I tried to include sqlite3 in my current C Project. = > > > = > > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my pro= > ject. > > Then, i downloaded the sqlite source and added sqlite3.h to my project. =

Re: [sqlite] [C] Linker Error

2008-03-08 Thread Clay Dowling
Severin Müller wrote: > I tried to include sqlite3 in my current C Project. > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. > Then, i downloaded the sqlite source and added sqlite3.h to my project. > > Now, when i try to compiler, i get the following error

[sqlite] [C] Linker Error

2008-03-08 Thread Severin Müller
Hi folks I tried to include sqlite3 in my current C Project. I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. Then, i downloaded the sqlite source and added sqlite3.h to my project. Now, when i try to compiler, i get the following error message:

Re: [sqlite] Odd problem with select on large table

2008-03-08 Thread BareFeet
Hi James, > / > sqlite3 test.db `select name from PerfTest1 where name = > "key5000"' > > does work. I know this because if I query for "key500" I get back > that row. It may work, but it's still wrong ;-) You should use single quotes for literals, which is correct SQL syntax. SQLite