[sqlite] UPDATE reports SQL logic error or missing database

2006-09-07 Thread Simon Posnjak
Hi all! When I try to do UPDATE of a record i get: SQL logic error or missing database (error code 1)? The database is not missing or corrupted because I can UPDATE stuff in it with sqlite3 and I can INSERT into, SELECT from it and also DELETE. My application uses two threads. The first thread

Re: [sqlite] SQLite vs MS Access

2006-09-07 Thread Alex Roston
I wrote a little server based on SQLite, and it works just fine. I handled the "multiple processes" issue by simply having the software make a list of requests, then handling those requests serially. Essentially there are two parts to the software. One listens for requests and lists them. It

Re: [sqlite] SQLite vs MS Access

2006-09-07 Thread Anne Kirchhellen
On Wed, 6 Sep 2006 18:05:36 +0100, you wrote: Hello Mark I think, either Access or ODBC is not a real good idea. SQLite is a real good idea, if you need a small embedded database. So far as I know, its even not a good idea, to compare MySQL and Postgres to SQLite, because MySQL is a

RE: [sqlite] SQLite vs MS Access

2006-09-07 Thread Robert Simpson
> -Original Message- > From: Allan, Mark [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 06, 2006 10:06 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite vs MS Access > > Hi, > > After successfully using SQLite on an embedded device, we are > now thinking of using

Re: [sqlite] Re: SQLite vs MS Access

2006-09-07 Thread John Stanton
George Ionescu wrote: Helo Allan, This would be used in place of an MS Access database on a local/network disk. I believe that SQLite should be quicker for both transactions and queries than Access. The one draw back that comes to mind maybe portability (i.e. accessing data outside of

[sqlite] [ANN] New DBManager Standard Edition 3.2.0

2006-09-07 Thread COS
DBTools Software is pleased to announce the new DBManager Standard Edition version 3.2.0. This application replaces the old DBManager Freeware Edition (3.1.1) and it can be used for FREE in the following conditions: - Personal use only You can register the Standard Edition at any time you want

[sqlite] How to find errors ?

2006-09-07 Thread Martin Alfredsson
Sorry if this messages dont follow the thread, I only have digest and I dont know how to attach msg to the correct thread. I have just now put together wiki pages that describe these errors. See http://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked

[sqlite] Re: SQLite vs MS Access

2006-09-07 Thread George Ionescu
Helo Allan, > This would be used in place of an MS Access database on a local/network disk. I believe that SQLite should be quicker for both > transactions and queries than Access. The one draw back that comes to mind maybe portability (i.e. accessing data outside of the > application),