Re: Re: [sqlite] Need help on build query.

Thanks --- [EMAIL PROTECTED] wrote: > "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > > Artem Yankovskiy > > > wrote: > > > I know about DROP TABLE. > > > I have not knew when compatibility DROP TABLE > and > > > SELECT... > > > > > > DROP TABLE (select name from sqlite_master > where...) > > >

Re: [sqlite] Need help on build query.

"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 2/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > Igor is correct - you cannot do that now. But I have sometimes > > wondered if it would be nice to add an exec() function to SQLite > > that would recursively invoke its argument as an

Re: [sqlite] Need help on build query.

On 2/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Igor is correct - you cannot do that now. But I have sometimes wondered if it would be nice to add an exec() function to SQLite that would recursively invoke its argument as an SQL script. For example: SELECT exec('DELETE FROM ' ||

Re: [sqlite] Need help on build query.

"Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > Artem Yankovskiy > wrote: > > I know about DROP TABLE. > > I have not knew when compatibility DROP TABLE and > > SELECT... > > > > DROP TABLE (select name from sqlite_master where...) > > did not work. > > Can I build resembling query? > > No. You