Re: [sqlite] SQLite under linux

Lloyd <[EMAIL PROTECTED]> was heard to say: > Unfortunately, I don't know how to install this library in my system. > Please help me.. If I am dealing with the wrong file, please let me know > from where I can get the needed installable library. > Maybe you should tell us which system you run.

Re: [sqlite] SQLite under linux

Martin Jenkins <[EMAIL PROTECTED]> was heard to say: > 3. make distclean doesn't remove the installed files from usr/local > I believe it is not supposed to. "make distclean" should remove any files from your build directory that either "configure" or "make" created. This usually returns your

Re: [sqlite] SQLite under linux

Thanks everybody, I have downloaded the library RPM from http://rpm.pbone.net/ and the library name is libsqlite-3.2.1-1.i386.rpm It may be useful for newbie like me... and did as what you said. And works fine... Thanks, Lloyd. On Wed, 2006-09-27 at 10:08 +0200, Markus Hoenicka wrote: >

[sqlite] Does SELECT cover uncommitted INSERTS?

Hi, list! I think my question is totally a newbie one, but still: Does a SELECT query return rows from uncommitted inserts on same sqlite3 handle (and same thread) ? I assume it does not do that when BEGIN; INSERT ...; END; is done on a distinct sqlite3 handle (and different thread).

[sqlite] How to get version of an SQLIte file

Hello I'm trying to develop an application with C# Mono and SQLite and I have a problem to know wich SQLIte version is the file I want open. Do you know a way to get this version before I open the file? LordPhoenix PS : Sorry for my English I'm french and don't speak this language very often

[sqlite] Re: Does SELECT cover uncommitted INSERTS?

Rafael Buchbinder wrote: Does a SELECT query return rows from uncommitted inserts on same sqlite3 handle (and same thread) ? Yes. The transaction sees any changes it itself has made. I assume it does not do that when BEGIN; INSERT ...; END; is done on a distinct sqlite3 handle (and

[sqlite] Re: Does SELECT cover uncommitted INSERTS?

Thanks a lot! -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 2:26 PM To: SQLite Subject: [sqlite] Re: Does SELECT cover uncommitted INSERTS? Rafael Buchbinder wrote: > Does a SELECT query return rows from uncommitted inserts on

[sqlite] auxiliary threads in sqlite3

I'm running with sqlite 3.3.6 in a windows environment. I have NOT defined "THREADSAFE=1". My app is single threaded, however, multiple instances of the app use sqlite3 on the same DB's, simultaneously. My question -- Does SQLite ever start auxiliary threads?

AW: [sqlite] auxiliary threads in sqlite3

I can't answer the question regarding SQLite for you, but Windows does start auxiliary threads in some APIs. -Ursprüngliche Nachricht- Von: Dixon [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 27. September 2006 16:36 An: sqlite-users@sqlite.org Betreff: [sqlite] auxiliary threads in

Re: [sqlite] auxiliary threads in sqlite3

Dixon <[EMAIL PROTECTED]> wrote: > I'm running with sqlite 3.3.6 in a windows environment. I have NOT > defined "THREADSAFE=1". My app is single threaded, however, multiple > instances of the app use sqlite3 on the same DB's, simultaneously. My > question -- Does SQLite ever start auxiliary

Re: [sqlite] How to get version of an SQLIte file

On Wed, 27 Sep 2006 14:06:50 +0200, you wrote: >Hello >I'm trying to develop an application with C# Mono and SQLite and I have >a problem to know wich SQLIte version is the file I want open. > >Do you know a way to get this version before I open the file? The first 15 bytes of the sqlite

[sqlite] How to link against sqlite3.dll

Hi, I'm trying to use the provided sqlite3.dll, but there is no .lib file available, so I have to extract the functions through their string names. Is there a lib file that I can just link against that will do that automatically. If there is, why isn't it included along with sqlite3.dll and if

[sqlite] Updating a whole column at once

I was about to post a question, and then I was embarrassed to find that I already asked the question more than 2 years ago, and I am still unsure of the answer. The question was: What is the fastest way to change the values in one column in every row? What I thought of was like so: BEGIN

Re: [sqlite] How to link against sqlite3.dll

On 9/27/06, Mike Polyakov <[EMAIL PROTECTED]> wrote: I'm trying to use the provided sqlite3.dll, but there is no .lib file available, so I have to extract the functions through their string names. Is there a lib file that I can just link against that will do that automatically. If there is, why

Re: [sqlite] Updating a whole column at once

On 9/27/06, James W. Walker <[EMAIL PROTECTED]> wrote: What is the fastest way to change the values in one column in every row? What I thought of was like so: BEGIN TRANSACTION; UPDATE MyTable SET TheCol=7 WHERE keyCol=1; UPDATE MyTable SET TheCol=8 WHERE keyCol=2; ... and so on for each row

Re: [sqlite] How to link against sqlite3.dll

Hi, Sorry I forgot to specify that. I am using Visual Studio 2005 C++ compiler. Right now I'm including all the .c file in my project and compiling it that way, but it would be nice to have a .lib file to link against and use the provided sqlite3.dll. (as I do under linux) On 9/27/06, Trevor