Re: [sqlite] expression syntax

) - easy to do, just use sqlite3_vmprintf instead to pick up the argument list. Paul

Re: [sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

ppreciated! Paul

[sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

abase is locked" errors without the timeout being honoured. I'm using sqlite 3.0.8 compiled for thread safety, running on Cygwin. Any clues gratefully received while I try this on some other platforms... Paul

Re: [sqlite] Sample code

Thanks, this is just what I was looking for. Paul - Original Message - From: "Clay Dowling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 29, 2004 9:27 AM Subject: Re: [sqlite] Sample code > > Paul Pigott said: > > I'm putting t

[sqlite] Sample code

oes anyone have a small example that I could refer to? I would greatly appreciate it. Thanks, Paul

RE: [sqlite] sqlite with Borland C++ 5.02

cated in the dynamic link library sqlite3.dll." whenever I try to execute the code from the IDE. I've defined the project as STATIC, and I've got the LIB file defined in the Project window. I'm still confused, but now I'm confused in a different way. TIA, Paul -Original Message-

RE: [sqlite] sqlite with Borland C++ 5.02

t;_sqlite3_open" instead of "sqlite3_open"). Based on the bit of reading I've done, does the .DEF file need to be changed around some on this as well? Again, thanks for everyone's help. Paul -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wedne

RE: [sqlite] sqlite with Borland C++ 5.02

Excellent. Thanks. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Borland C++ 5.02 Pigott, Paul wrote: > Is there a pre-compiled binary for that? Or do you just conv

RE: [sqlite] sqlite with Borland C++ 5.02

Is there a pre-compiled binary for that? Or do you just convert the .DLL to a .LIB with a utility? Paul -Original Message- From: nfr [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Borland C++ 5.02 Pigott

[sqlite] Is it possible to 'fix' a malformed database

of errors?) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

Re: [sqlite] Apostrophes in strings

ter (MySQL (and some others) are incorrect to use \' - those need escaping of the \ character as well, which isn't necessary with the proper SQL method) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

Re: [sqlite] Problems adding a new column

* from Address PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] vers 3.0 concurrency issues

he hard work in this case. If there was no callback registered, SQLite would act like it does now, with file level locks PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://ww

[sqlite] Ticket 575

Is there any progress on this ticket (temporary file storage method problem)? If not, can anyone suggest any workarounds? I've just discovered here that it looks like we're getting really bad performance hits on a Windows machine with temporary files when people use certain virus scanners.

[sqlite] SQLite version 3.0

I've looked at the proposed changes for SQLite V3, and, whilst it all looks reasonable, it does absolutely nothing for me... The things I'd like would be more at the 'lower' levels of the database. I'd like to see the query engine be able to use multiple indices if appropriate, rather than

Re: [sqlite] A proposal for SQLite version 3.0

rce level. Perhaps, should it become a concern, offer the option at compile time to have 32/64/n bit keys. Far too often I've seen stone-cast items such as this become the agony of others. Paul. -- Paul L Daniels - PLD Software - Xamime Unix systems Internet Development A.B.N. 19 500 721 806 ICQ#

Re: [sqlite] Command-line SQLite

At 15:20 28/11/2003, [EMAIL PROTECTED] wrote: I'm attempting to use the command-line SQLite to test the speed of certain "selects" and how writing them in different fashions affects speed OK, can anyone explain (no pun intended!) what I should be looking for in what information "explain"

Re: [sqlite] Concurrency in SQLite

At 16:21 24/11/2003, Doug Currie wrote: It looks to me that several users are (a) in a uniprocess environment, and (b) inventing their own SQLite db access synchronization code. An SQLite fine grained lock manager for threads in a single process would address these same issues, with better

Re: [sqlite] Improving concurrency in SQLite

Looking at the feedback paper, I wonder whether, possibly, things are being made more complicated than necessary. In most (if not all) of the situations I've seen people mention where concurrency is a problem (and in our own similar situation), it looks as if the problem is all in 'single

Re: [sqlite] Where statements are they case sensitive?

I just checked something and noticed that the WHERE statement is case sensitive. I have check this in SQL Server and it is not case sensitive. I am using 2.8.5 and 2.8.6. As an example in the northwind DB I have for SQLite . There is a table called Orders select * from sqlite_master where

<    3   4   5   6   7   8