On 1/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> I wrote sqlite3_exec(...., ".shema test", ....). The response was:

did you type .shema or was that a typo. How about .schema instead of .shema


".schema" is a command implemented in sqlite3.exe, it's not a valid
SQL statement that you can execute via a sqlite3_exec() from C.

But you can use above mentioned "PRAGMA table_info(tbl_name);", which
is a valid SQL statement in SQLite and you can execute it via a
sqlite3_exec() from C.

http://www.sqlite.org/pragma.html#schema

--
Nemanja Corlija <[EMAIL PROTECTED]>

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to