subject:"\[sqlite\] Newbie SQL question"

Re: [sqlite] Newbie SQL question

2007-02-06 Thread A.J.Millan

Dennis: Thank you very much for your's Help. A. J.Millan - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 06, 2007 11:16 PM Subject: Re: [sqlite] Newbie SQL question > > > Yes. See the documentation for

Re: [sqlite] Newbie SQL question

2007-02-06 Thread Dennis Cote

A.J.Millan wrote: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? Yes. See the documentation for PRAGM

[sqlite] Newbie SQL question

2007-02-06 Thread A.J.Millan

Hi all: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? Thanks in advance --- A.J.Millan ZATOR Syst