Re: [sqlite] SQLite now supports ALTER Table?

Raymond Irving wrote: Hey check this out: This SQLiteDB php class allows you to use ALTER TABLE with your sqlite database. http://code.jenseng.com/db/ I'd really be interested to know how they handle tables with UNIQUE columns, because those are tricky.

[sqlite] SQLite now supports ALTER Table?

Hey check this out: This SQLiteDB php class allows you to use ALTER TABLE with your sqlite database. http://code.jenseng.com/db/

Re: [sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

One work around is to load the results of your SELECT into a TEMP table, then loop through the TEMP table to do your DELETEs. SQLite does allow you to delete, update, or insert tables from within the middle of a select as long as the tables being updated, deleted, or inserted are distinct from

Re: [sqlite] Library routine called out of sequence

Guillaume Fougnies wrote: You are probably working in a threaded environment and a sqlite* is shared by at least two threads. Even more common than that is calling sqlite3_step() after a prior call to sqlite3_finalize(). Basically, you are misusing the API. Instead of just segfaulting, SQLite was

Re: [sqlite] Library routine called out of sequence

You are probably working in a threaded environment and a sqlite* is shared by at least two threads. bye. Fri, Oct 22, 2004 at 10:44:22AM +0200: P. Morandi wrote: > Hi everybody. > Does anybody know the main causes of error 'Library routine called out of sequence' > after a sqlite_exec()

Re: [sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

Hi, My program model in effect was a Component based model whereby I created an Object Enumerator which is currently implemented as an SQLite Select Query and whilst enumerating the objects I was then calling Delete() on some objects to tell them to destroy. The problem with SQLite was that i

Re: [sqlite] Table locked when trying to delete a record whilst a cursor to the table is open

Clay Dowling wrote: Andrew, What you're trying to do won't work. Clay is correct. The btree code in SQLite will get confused if you delete (or otherwise modify) entries in a table while SQLite is trying to scan that table. This means that you cannot do a DELETE on the table in the middle of a

Re: [sqlite] Wich compiler to use in Windows

Cory Nelson wrote: Use the Visual C++ Toolkit. http://msdn.microsoft.com/visualc/vctoolkit2003/ It is free, and optimizes much better than MinGW and LCC-Win32. I can't compare it to Borland's, I've never used that one. On Wed, 20 Oct 2004 10:41:25 -0200, Rubens Jr. <[EMAIL PROTECTED]> wrote:

[sqlite] Temp Store

Hi there,   Sorry to bother you with a simple question, but where does this reside by default (i.e. file)?   I have changed my project to use in-memory temp-store, but the program won't start as the temp store already exists on disk.  I can't locate the file however - I have deleted the

[sqlite] Library routine called out of sequence

Hi everybody. Does anybody know the main causes of error 'Library routine called out of sequence' after a sqlite_exec() calling? Thank you. P. Morandi