[sqlite] OT: Compiling under Windows

Hello, this question is slightly OT here but. I want to compile SQLite as a library (not as a DLL) and add this library to my DLL-Project. Why? Because the C-Compiler from MS produces so many warnings and I want to compile all my own projects without even a single warning So I wonder

RE: [sqlite] multiple thread concurrency problem with exclusive transaction locks

I am not running on *ix, so I cannot test.however, your mentioning multi-cpu machines, brings something to mind. In windows, most synchronization functions rely on some form of INTERLOCKED operation. Now, these operations are implemented differently on multi-cpu (and hyperthreading counts as

Re: [sqlite] SQLite openning a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christian Smith wrote: > On Tue, 11 Jan 2005, John Richard Moser wrote: > > >>-BEGIN PGP SIGNED MESSAGE- >>Hash: SHA1 >> >>http://rafb.net/paste/results/jRFmZD25.html >> >>This is code from a package manager I'm writing based on SQLite.

Re: [sqlite] add new column to table

Hi Dennis, I tried something similar to your recommendation, but there was a problem with the following INSERT INTO call_data SELECT old_call_data.*, firstname || ' ' || surname FROM old_call_data JOIN users USING extn_no; there is a syntax error near extn_no. Lloyd - Original

Re: [sqlite] mailing list problems?

I also; I sent in a couple of messages on Monday and I haven't seen them post. --Keith On Wed, 12 Jan 2005 09:20:13 -0700, Dennis Cote <[EMAIL PROTECTED]> wrote: > Hi, > > Yesterday I posted three messages to the mailing list. Today when I look at > the list only the last of those three

Re: [sqlite] add new column to table

Lloyd Thomas wrote: Thanks Dennis. As long as I know where I stand. I can probably use PHP or Delphi to update each row manually. Lloyd - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: "sqlite-users" Sent: Wednesday, January 12, 2005 4:21 PM

Re: [sqlite] $ in table and column names

Dennis Cote wrote: For what it' worth now, here is the first message I posted yesterday. It might to make my last post make a little more sense. Hanging head in shame... That didn't clarify anything did it. It should have said: "For what it's worth now, here is the first message I posted

Re: [sqlite] mailing list problems?

Everything I try to post is marked as spam and rejected. --- Dennis Cote <[EMAIL PROTECTED]> wrote: > Hi, > > Yesterday I posted three messages to the mailing list. Today when I > look at > the list only the last of those three messages has been distributed > back to > my email account. > >

Re: [sqlite] add new column to table

Thanks Dennis. As long as I know where I stand. I can probably use PHP or Delphi to update each row manually. Lloyd - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: "sqlite-users" Sent: Wednesday, January 12, 2005 4:21 PM Subject: Fw:

Fw: [sqlite] $ in table and column names

For what it' worth now, here is the first message I posted yesterday. It might to make my last post make a little more sense. Dennis Cote wrote: Ulrik Petersen wrote: I guess the next question is: Can someone verify that this is part of the SQL standard? Yes, it looks like this is part of the

Fw: [sqlite] add new column to table

Dennis Cote wrote: Lloyd Thomas wrote: Thanks. That is going OK but I am having a problem with updating the new column with the info I need. It seems to update with the same entry from my users table to all rows. UPDATE call_data SET caller_name = (SELECT firstname || surname AS 'caller_name' FROM

[sqlite] mailing list problems?

Hi, Yesterday I posted three messages to the mailing list. Today when I look at the list only the last of those three messages has been distributed back to my email account. Has anyone else noticed the mailing list failing to distribute messages? Dennis Cote

Re: [sqlite] SQLite openning a database

On Tue, 11 Jan 2005, John Richard Moser wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >http://rafb.net/paste/results/jRFmZD25.html > >This is code from a package manager I'm writing based on SQLite. These >two functions open a database, creating it if it doesn't exist. > >While most

Re: [sqlite] regd. sqlite 3

Hi Neera, neera sharma wrote: thankx Ulrix for replying. I am using sqlite_exec with call back option. Neera. From http://sqlite.org/capi3ref.html#sqlite3_step " SQLITE_MISUSE means that the this routine was called inappropriately. Perhaps it was called on a virtual machine that had already

Re: [sqlite] regd. sqlite 3

thankx Ulrix for replying. I am using sqlite_exec with call back option. Neera. --- Ulrik Petersen <[EMAIL PROTECTED]> wrote: > neera sharma wrote: > > >I am using sqlite3. when i pass an sqlite command > >string, following error is reported - > > > >"SQL error: library routine called out of

Re: [sqlite] regd. sqlite 3

neera sharma wrote: I am using sqlite3. when i pass an sqlite command string, following error is reported - "SQL error: library routine called out of sequence" Could anybody suggest the correct way of doing it. Do you want to use the "sqlite3_exec with callback function" API? Or the

[sqlite] regd. sqlite 3

I am using sqlite3. when i pass an sqlite command string, following error is reported - "SQL error: library routine called out of sequence" Could anybody suggest the correct way of doing it. __ Do you Yahoo!? Read only the mail you want -