RE: [sqlite] Thread locking issues on RH9

The behavior of Fcntl might have changed in red hat 9 because of the change in thread library. (I have a Enterprise version of Redhat (V3) if you want me to test something) Google the comp.programming.threads & linux.kernal groups. You can specify that you want to use the older LinuxThreads

RE: [sqlite] How to insert a string using C interface that contains both single and double quotes

Try this char * EscapedQuery = sqlite3_mprintf("%q",MyQuery); ///.. Do some Stuff .. execute query..etc.. sqlite3_free(EscapedQuery); -- JB -Original Message- From: Sergey Startsev [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 11:45 AM To: Sankara Narayanan Subject: Re:

RE: [sqlite] Does sqlite really support transaction?

>Jay Sprenkle wrote: >The transaction doesn't seem any different than a snapshot of the >database that you can restore to. I just wondered why there were two >methods of doing the same thing. Only in a single user/single thread case are they the same thing. With Sqlite that might always be

RE: [sqlite] Does sqlite really support transaction?

A transactions is exactly like the original poster stated it. Assuming all Update, Select, Insert Commands are Atomic. A transaction allows the user to group a bunch of commands together and state they should be considered atomic, whereas if there is "a failure", then none of them are committed.

RE: [sqlite] Does sqlite really support transaction?

I can think of no way to implement complex atomic transactions with rollbacks in a flat SQL script. You need some sort of higher level language to make decisions about results .. IE C++ etc.. -- JB -Original Message- From: Vladimir Zelinski [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: [sqlite] Does sqlite really support transaction?

Any return other then 0 from the API function you use to exec your SQL statement is a fail. -- JB -Original Message- From: Vladimir Zelinski [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 10:31 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Does sqlite really support

RE: [sqlite] REGEXP as an operator

operator On 5/10/05, John Buck <[EMAIL PROTECTED]> wrote: > Greetings, > > I am new to this list and the Sqlight project. > > I ran across it while doing research on locating an alternative to the Mysql > Embedded engine. Sqlite seems like it will do the trick with a few t

[sqlite] REGEXP as an operator

REGEXP is used as an operator. (IE: Field REGEXP '.*10$' ). The changes are simple enough that maybe they can be added to the next release. -- John Buck [EMAIL PROTECTED]