Re: [sqlite] precompiled SQL and transactions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christian Smith wrote: | This has come up on the list before, and should probably be documented on | the Wiki in http://www.sqlite.org/cvstrac/wiki?p=PrecompiledSql. [...] | As the sqlite3_compile API is still experimental (the SQLite V3 API |

Re: [sqlite] Test

On 6 ago 2004, at 13:34, Peter Lau wrote: it works... what's up? On Aug 5, 2004, at 11:41 AM, Tito Ciuro wrote: Test It didn't seem to work yesterday. I though the mailing list was down... -- Tito

Re: [sqlite] Why is 'database schema has changed' being reported?

Hello again, Following the email I sent yesterday, I've discovered why I get a SQLITE_SCHEMA error: VACUUM changes the schema version numbering. The question is why? The schema is exactly the same, it has the same tables, columns and indexes. Sure, the data is now compacted, but what has this

Re: [sqlite] Test

it works... what's up? On Aug 5, 2004, at 11:41 AM, Tito Ciuro wrote: Test

Re: [sqlite] Compiling Linux SQLite with thread safe

Corwin Burgess wrote: I'm looking for some help in compiling a Linux version of SQLite v2.8.15 that is thread safe capable. Corwin Ignore my previous message using zip file. I used the Makefile.linux.gcc to compile the source files in sqlite-source-2.8.15.tar.gz from Fedora Core 1. I modified

[sqlite] QNX and PPC

Hello everybody, does someone have any experience with building for the QNX operating system? And for the Power PC processor? QNX 6.2.1 is a real-time Linux but it behaves strangely sometimes. It has not gcc but a qcc compiler. Our testing program runs correctly on the x86 PC. It creates a

[sqlite] Return value of authorizer callback

Hello, according to the documentation of sqlite3_set_authorizer(), the callback sould return SQLITE_OK, SQLITE_DENY or SQLITE_IGNORE. My questions: a.) What is the behavour of sqlite, if the callback returns a value that isn't allowed? What will sqlite3_prepare() return in this situation? b.)

Re: [sqlite] Lemon Parser Examples - I'll show you my examples

Many thanks for your contribution! -joe On Wed, 4 Aug 2004 22:02:48 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > A user earlier posted a question about terminating > the grammer for a simple calculator done with lemon. > > I ran into the same problem and had to use > the following,

[sqlite] Test

Test smime.p7s Description: S/MIME cryptographic signature

[sqlite] Mailing list problem

According to the instructions at http://www.sqlite.org/support.html... "For additional information about operating and using this mailing list, send a message to [EMAIL PROTECTED] and instructions will be sent by to you by return email." This doesn't seem to be working. I've tried twice. -

[sqlite] sqlite date?

hi, can i use date type in sqlite or i must save as varchar? thx yesso

[sqlite] Fwd: Why is 'database schema has changed' being reported?

Hello, This happens with SQLite 3.0.3 on Mac OS X 10.3.4. I'm issuing a simple 'SELECT * FROM people' on my database. When I reach 'sqlite3VdbeExec', it falls on the following error: if( rc==SQLITE_OK && iMeta!=pOp->p2 ){ sqlite3SetString(>zErrMsg, "database schema has changed", (char*)0);

Re: [sqlite] precompiled SQL and transactions

This has come up on the list before, and should probably be documented on the Wiki in http://www.sqlite.org/cvstrac/wiki?p=PrecompiledSql. As to whether it's a problem, I think probably not as the 'fix' is so trivial. If you want to fix, then simply wrap the begin/compile/commit in a new function

RE: [sqlite] Building for Windows

On Thu, 5 Aug 2004, Dennis Volodomanov wrote: >I'm sorry, but I just can't build it :-( I'm using CygWin and I've ran >the 'configure' command and then I type 'make' and this is what I get: > >$ make >./libtool --mode=compile gcc -g -O2 -DOS_WIN=1 -DHAVE_USLEEP=1 -I. >-I./src -DNDE >BUG -c

[sqlite] Why is 'database schema has changed' being reported?

Hello, This happens with SQLite 3.0.3 on Mac OS X 10.3.4. I'm issuing a simple 'SELECT * FROM people' on my database. When I reach 'sqlite3VdbeExec', it falls on the following error: if( rc==SQLITE_OK && iMeta!=pOp->p2 ){ sqlite3SetString(>zErrMsg, "database schema has changed", (char*)0); rc =

Re: [sqlite] Compiling Linux SQLite with thread safe

Corwin Burgess wrote: I'm looking for some help in compiling a Linux version of SQLite v2.8.15 that is thread safe capable. Corwin I've decided to compile a Linux sqlite library using the sqlite-source-2_8_15.zip file with the Fedora Core 1 distro. I created the following directory structure

Re: [sqlite] Compiling sqlite3.0.3 on dec-osf1 with gcc 3.04 failed

I added `-DUINTPTR_TYPE=u64' to the TCC line of the Makefile but it does not help either! [EMAIL PROTECTED]:/project/amphioxus/src/sqlite-3.0.3/build> gmake clean all rm -f *.lo *.la *.o sqlite3 libsqlite3.la rm -f sqlite3.h opcodes.* rm -rf .libs .deps rm -f lemon lempar.c parse.*