[sqlite] Novice Inserting TEXT/BLOB question

Hi all, I'm new to sqlite and was having problems inserting quoted text. I figured out the ' ' and " " requirements and it resolved my issues, however I'm curious to know if there are other characters that also require this form of escaping? Is there a list somewhere? Thanks, Chris. -- Chris

[sqlite] locking via windows nfs client

has anyone out there used sqlite from a windows machine when the db resided on an nfs filesystem mounted using the windows nfs client? if so, does it work? have you attempted concurrent access from other windows machines? other *nix machines? i'm considering an application where process from

RE: [sqlite] Rowid in VIEWs?

Heh. Didn't think about precompiled queries at all. Have to look into that. The description you give is what I am already writing to handle it from the C++ side, so it looks like I'm half-way there . Thanks for the help. --Keith -Original Message- From: Dennis Cote [mailto:[EMAIL

Re: [sqlite] Rowid in VIEWs?

Keith Herold wrote: > The short question: do (temporary) VIEW's have rowid's in SQLITE? The short answer: no. You don't say how you are accessing the database, but if you are using C, then you can simply use the precompiled query interface to perform your lookup and return your result in small

Re: [sqlite] New SQL Function.

Is there some form of documentation that should all the functions allowed inside an SQL statement? For example: DATE(), CASE, etc __ Raymond Irving --- Doug Currie <[EMAIL PROTECTED]> wrote: > > Wednesday, August 18, 2004, 1:45:43 PM, Federico > wrote: > > > [...] > > > gcc -g -O2

Re: [sqlite] New SQL Function.

Wednesday, August 18, 2004, 1:45:43 PM, Federico wrote: > [...] > gcc -g -O2 -DTHREADSAFE=1 -DOS_UNIX=1 -DOS_WIN=0 -DHAVE_USLEEP=1 -I. > -I../sqlite/src -DHAVE_READLINE=0 > -o .libs/sqlite ../sqlite/src/shell.c ./.libs/libsqlite.so > ./.libs/libsqlite.so: undefined reference to `sqrt' >

[sqlite] New SQL Function.

Sorry for my english. I try to add a new SQL function (sqrt) as described at http://www.hwaci.com/sw/sqlite/c_interface.html#cfunc If I try (for understanding pourpose only) to return the same value I give to the function it's all ok, then (for a little experiment) I try to return the abs and

[sqlite] FileLocks - help requied

Hi, I am currently porting sqlite 3.0 into my device application. The device is running on an ARM7TDMI processor. The filesystem available on device is Nucleus file system. For this file system I am not sure whether I have the file locking mechanisms as provided in Sqlite 3.0. But the

Re: [sqlite] [sqlite-lemon] Lemon Parser Generator Tutorial

[EMAIL PROTECTED] wrote: Freshmeat has a tutorial on the Lemon Parser Generator. http://freshmeat.net/articles/view/1270/ This tutorial walks you through a simple calculator. It would be also interesting to have an example of using Lemon + RE2C (http://re2c.sf.net). I think RE2C lexer works