Re: [sqlite] Adding/Removing fields?

2004-09-27 Thread Chan Wai Wa, Raymond
On Mon, 27 Sep 2004 22:15:58 -0700, Eric Scouten <[EMAIL PROTECTED]> wrote: > Peter Loveday wrote: > > > Greetings! > > > > Is there any way to add or remove field(s) from a table, short of > > copying the entire thing to a newly created table with the desired > > schema? > > No. See http://sqlit

Re: [sqlite] Adding/Removing fields?

2004-09-27 Thread Eric Scouten
Peter Loveday wrote: Greetings! Is there any way to add or remove field(s) from a table, short of copying the entire thing to a newly created table with the desired schema? No. See http://sqlite.org/faq.html#q13 for the closest alternative (which is basically a variant of copying the whole thing

[sqlite] Adding/Removing fields?

2004-09-27 Thread Peter Loveday
Greetings! Is there any way to add or remove field(s) from a table, short of copying the entire thing to a newly created table with the desired schema? Love, Light and Peace, - Peter Loveday Director of Development, eyeon Software

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

2004-09-27 Thread D. Richard Hipp
Kazuho Oku wrote: Unfortunately, my apache module only performs a single SELECT clause of which WHERE clause can be indexed. What I am wondering is the way to stop calling SQLite each time the module processes an HTTP request (eliminate the FLOCK -> READ -> FUNLOCK done by SQLite). I think you are

Re: [sqlite] Receiving notification of table updates

2004-09-27 Thread Kazuho Oku
> From: "Hihn, Jason" <[EMAIL PROTECTED]> > What is updating the table? Another [apache module] thread or another > process? > > If they are from the same module, I'd think you could use a static int > or semaphore. There's also shared memory. Some CGIs and cron jobs are updating the table, so so

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

2004-09-27 Thread Kazuho Oku
Thank you for the response. Unfortunately, my apache module only performs a single SELECT clause of which WHERE clause can be indexed. What I am wondering is the way to stop calling SQLite each time the module processes an HTTP request (eliminate the FLOCK -> READ -> FUNLOCK done by SQLite). # sor

[sqlite] A problem with the select statement

2004-09-27 Thread Ishwar . Jasuja
Return Receipt Your [sqlite] A problem with the select statement document :

[sqlite] Re: calling sqlite3_create_function after sqlite3_prepare?

2004-09-27 Thread Vladimir Vukicevic
Any ideas on this? Seems to be another problem here as well -- sqlite3_errcode is often not returning the same error code as was returned by a previous sqlite3 call. I've filed tickets #926 and #927 for these issues, along with a code sample demonstrating the problem. Thanks, - Vlad

RE: [sqlite] Receiving notification of table updates

2004-09-27 Thread Hihn, Jason
What is updating the table? Another [apache module] thread or another process? If they are from the same module, I'd think you could use a static int or semaphore. There's also shared memory. > -Original Message- > From: Kazuho Oku [mailto:[EMAIL PROTECTED] > Sent: Monday, September 27,