[sqlite] Compiling sqlite3 CVS version: ./configure --enable-threadsafe failed

If I compile the CVS version with the following option. ./configure --enable-threadsafe I get an error when running Make, unless I add "-lpthread" to the Makefile as follows. LIBREADLINE = -lreadline -lncurses -lpthread For some reason, configure isn't adding in the "-lpthread" linker opti

Re: [sqlite] Inserting Qutoed Text

Hi Mike, had the same problem switching from msql to sqlite a few days ago. You have to use two single quoting characters '' (C style) instead of \' and it'll work. Stefan Michael MacFadden schrieb: > > Hi, > > I am trying to insert some text into a table, but the text has some > quote charac

Re: [sqlite] QNX and PPC

Jakub Adamek wrote: Thank you for the explanation. And this file is always created even if I do not use TEMP tables? Because I am not using them. You always have an SQLITE_TEMP_MASTER table, which is also stored in the same temporary file. D. Richard Hipp wrote: Jakub Adamek wrote: I only wonder,

Re: [sqlite] QNX and PPC

Thank you for the explanation. And this file is always created even if I do not use TEMP tables? Because I am not using them. Jakub D. Richard Hipp wrote: Jakub Adamek wrote: I only wonder, what is the file SQLite creates in /tmp? My program calls "CREATE TABLE", "INSERT" and "SELECT". Why does SQ

Re: [sqlite] SQLite 3 for Pocket PC

Thank you, the port was very useful for me. For those interested, I am sending the diff results. Jakub Nuno Lucas wrote: Jakub Adamek, dando pulos de alegria, escreveu : Somebody mentioned here he/she has SQLite 3 working on Pocket PC. Could you please send the sources or diffs? The 3.0.3 versi

Re: [sqlite] QNX and PPC

Jakub Adamek wrote: I only wonder, what is the file SQLite creates in /tmp? My program calls "CREATE TABLE", "INSERT" and "SELECT". Why does SQLite need some temporary file? That temporary file is where it stores temporary tables created using CREATE TEMP TABLE and so forth. Additional temporar

Re: [sqlite] QNX and PPC

Hello, if anyone was watching my efforts, I have just won! The PowerPC machine I am using had the folder /tmp mapped into shared memory and the file-locking did not work with it. I changed the sqlite3OsTempFileName() function and everything is fine. I only wonder, what is the file SQLite creates

Re: [sqlite] Inserting Qutoed Text

Michael MacFadden <[EMAIL PROTECTED]> writes: > I am trying to insert some text into a table, but the text has some quote > characters in it. For example, lets say I have the following table. > > Performing the following insert won't work: > > INSERT INTO test ( col2 ) VALUES ('This doesn't work'

Re: [sqlite] Inserting Qutoed Text

On Aug 13, 2004, at 6:23 AM, Michael MacFadden wrote: I already have this working in MySQL and PostgreSQL and am trying to add support for SQLite. I am definitely a novice of SQLite. Is there some way to properly escape single and or double quotes, or do I have some obvious syntactical error?

[sqlite] Inserting Qutoed Text

Hi, I am trying to insert some text into a table, but the text has some quote characters in it. For example, lets say I have the following table. CREATE TABLE test ( col1 INTEGER PRIMARY KEY NOT NULL, col2 varchar(255) NOT NULL default '' ); Performing the following insert won't work: INSERT

Re: [sqlite] Status of FOREIGN KEY implementation

On Wed, Aug 11, 2004 at 05:09:49PM -0700, Cliff Hudson wrote: > engine in a mobile device. Foreign key constraints are one of the features > I would like to see in any database engine we eventually use. According to > the web site, this feature is not yet implemented, and the mailing list This

[sqlite] Re: sqlite3_busy_timeout ignored while doing multi-threaded updates ?

More information on this: Busy handler's return value is indeed ignored: in sqlite3pager_begin I've seen this: .. #if 0 int busy = 1; do { rc = sqlite3OsLock(&pPager->fd, RESERVED_LOCK); }while( rc==SQLITE_BUSY && pPager->pBusyHandler && pPager->pB