Re: [sqlite] Re: Re: how to get field names of empty tables ?

Scott Hess wrote: I think only the dot commands are special (.help, etc). Everything else is fair game. Best reference for what you can feed a prepare or exec is http://www.sqlite.org/lang.html . Scott, thanks for this valuable information. Now how beautiful it would be if it was all in 1

Re: [sqlite] Re: Re: how to get field names of empty tables ?

I think only the dot commands are special (.help, etc). Everything else is fair game. Best reference for what you can feed a prepare or exec is http://www.sqlite.org/lang.html . -scott On 2/23/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: > Igor

[sqlite] Re: Re: how to get field names of empty tables ?

Stef Mientki <[EMAIL PROTECTED]> wrote: Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: is there an SQL statement to get the field-names of empty tables ? PRAGMA table_info(tableName); I had seen that command, but I wrote something about that these commands could only be run