Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Martin Jenkins
John Stanton wrote: Martin Jenkins wrote: He's not making a point - it's British (dry, subtle) humour. Very perspicaceous old chap. ;-) And efficacious in every way ;) Toodle pip! Martin - To unsubscribe, send ema

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Martin Jenkins
jose isaias cabrera wrote: I got it right away. And I just don't laugh for the fun of it. :-) It's gotta be funny. Was it a tad harsh? Yeah... But it was funny. See http://c2.com/cgi/wiki?ZenSlap Martin - To unsubs

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Martin Jenkins
G. Roderick Singleton wrote: In bad taste if that what the attempt was. ;-( It's hardly bad taste Would it have tasted better it I'd said it was a rhetorical question?:o) Martin - To unsubscribe, send email to

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread John Stanton
Martin Jenkins wrote: G. Roderick Singleton wrote: On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: If you find a way to drop a table which dosn't exist. let us know how you do it. Thanks for your insight. However what's your point? That the OP didn't check the website, that my

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread P Kishor
DROP TABLE [IF EXISTS] DROP INDEX [IF EXISTS] CREATE TABLE [IF NOT EXISTS] and so on... On 1/25/07, Nicolas Williams <[EMAIL PROTECTED]> wrote: On Thu, Jan 25, 2007 at 10:35:23AM -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that?

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 18:40 +, Martin Jenkins wrote: > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > > > >> If you find a way to drop a table which dosn't exist. let us know how > >> you do it. > >> > > Thanks for your insight. However what's

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Nicolas Williams
On Thu, Jan 25, 2007 at 10:35:23AM -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? You'd think this would work: SELECT CASE WHEN (SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = 'foo') > 0 THE

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread jose isaias cabrera
bject: RE: [sqlite] How to conditionally drop a table? -Original Message- From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 12:06 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to conditionally drop a table? On Thu, 2007-01-25 at 11:13 -0600

RE: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Fred Williams
> -Original Message- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 25, 2007 12:06 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to conditionally drop a table? > > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Martin Jenkins
G. Roderick Singleton wrote: On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: If you find a way to drop a table which dosn't exist. let us know how you do it. Thanks for your insight. However what's your point? That the OP didn't check the website, that my reference was incorrect

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > If you find a way to drop a table which dosn't exist. let us know how > you do it. > > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > > > >>I need a way to drop a table only if that tabl

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread John Stanton
If you find a way to drop a table which dosn't exist. let us know how you do it. G. Roderick Singleton wrote: On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: I need a way to drop a table only if that table exists. How would I do that? Thanks, Are you asking if http://sqli

RE: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Anderson, James H \(IT\)
t: Re: [sqlite] How to conditionally drop a table? On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? > > Thanks, Are you asking if http://sqlite.org/lang_droptable.html works or have you ha

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? > > Thanks, Are you asking if http://sqlite.org/lang_droptable.html works or have you had problems? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH

[sqlite] How to conditionally drop a table?

2007-01-25 Thread Anderson, James H \(IT\)
I need a way to drop a table only if that table exists. How would I do that? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is pr