Re: [sqlite] Multiple Updates

Hi Trevor, Thanks, that makes a big difference to the way I thought it worked. Regards, Chris Trevor Talbot wrote: On 9/29/06, Chris Gurtler <[EMAIL PROTECTED]> wrote: A transaction has the select statements in one single string starting with a begin and ending with an end. I

Re: [sqlite] Multiple Updates

Hi Trevor, A transaction has the select statements in one single string starting with a begin and ending with an end. I have a column which is a BLOB, and this may contain control characters like NULL. Regards, Chris Trevor Talbot wrote: On 9/28/06, Chris Gurtler <[EMAIL PROTEC

Re: [sqlite] Multiple Updates

Thanks, I wish I could use transactions, but because I'm updating a blob I need to do it that way. Ill check out the PRAGMA option to see if that helps. Regards, Chris He Shiming wrote: Hi All, Is it possible to do multiple updates of blobs using the bind variables, I was doing them 1 a

[sqlite] Multiple Updates

Hi All, Is it possible to do multiple updates of blobs using the bind variables, I was doing them 1 at a time but it was a little slow. For example :- rc = sqlite3_prepare(objects_db, "UPDATE table SET proprietary_data = ? WHERE device_id = ? and instance = ?", -1, &pStmt, 0); for (i= 0; i

Re: [sqlite] Most appropriate Web based database? (Newbie)

Hi Lenster, For a Web application you are probably better off with MySQL, it runs as a seperate process and handles multiple threads really well. I'm probably going to offend the sqlite people out there, but sqlite is fantastic for an embedded database, and a web app is not what I would call

[sqlite] Using the Precompiled Binaries on Linux

Hi All, This is hopefully a really basic question for someone. I have downloaded the precompiled binary for Linux and I've got a file called sqlite-3.2.8.so.gz So far so good, but I'm not sure what steps to use to install this properly. Should I extract it and copy it into \usr\lib and the

[sqlite] SQLite is Awesome

Hi, Ok, so Mr. Hipp's spelling may need a little work, but SQLite has got to be the best bit of software that I have come accross for quite a while. Thank you !! Regards, Chris

Re: [sqlite] SQL Queries

t; <[EMAIL PROTECTED]> To: Sent: Tuesday, September 27, 2005 4:37 AM Subject: Re: [sqlite] SQL Queries Chris Gurtler wrote: I'm pretty new to SQLite, and am just looking for a few pointers on SQL queries, this is an example of a query from a crapy MS Access database that I want to conv

[sqlite] SQL Queries

Hi, I'm pretty new to SQLite, and am just looking for a few pointers on SQL queries, this is an example of a query from a crapy MS Access database that I want to convert to SQLite, but it fails. it says c.group_id does not exist. I'm wondering if anyone has got some tips on multiple joins, I