Sqlite3_complete does no syntax checking other than to see if the SQL
statement is terminated with a semi-colon. It is used to split multiple
SQL statements in the same string, not verify syntax.
Why not use the Sqlite SQL syntax checker by running sqlite3_prepare on
your statement?
You can
--- [EMAIL PROTECTED] wrote:
> ...
> Most of the interfaces in bind.test are
> special-purpose
> testing hacks that are only available if you build
> the "testfixture". They are not a part of the
> standard
> TCL API.
>
> ...
> Three things to take away from this overview:
>
> (1) The TCL API
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> I pulled the following from the bind.test file. It shows how
> sqlite_prepare is used to test the parameter binding, and how the
> sqlite_column_count and sqlite_column_name APIs are used.
>
Most of the interfaces in bind.test are special-purpose
test
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> I pulled the following from the bind.test file. It
> shows how
> sqlite_prepare is used to test the parameter
> binding, and how the
> sqlite_column_count and sqlite_column_name APIs are
> used.
>
> HTH
> Dennis Cote
Dennis,
This is great! These
Unit 5 wrote:
Thank your very much for your answers! It looks like
sqlite3_prepare() is what I need.
I have gone through the tcl api and did not find any
mappings to it or any command that matched its
functionality. Do you have the reference or the
command name handy?
Unit,
I don't
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> What you probably want to do is use
> sqlite3_prepare() to check if the
> statement is syntactically valid. If it is you will
> get a success return
> code, if not you will get an error return code.
>
> I understand you are using TCL but I believe all
Hi 'Unit 5',
3) I would like to test the validity of sql statements
before executing them. So I thought I could use "db
complete" command. But now I am not sure what "db
complete" command does. In my tests, it returns 0
(false) regardless of the sql statement. In fact the
only times I have g
Unit 5 wrote:
1) If I have a statement that includes "WHERE 0 = 1",
does sqlite optimize the query and return right away
or would it execute the query anyway?
It will be executed.
2) Is there a way to get column names form a statement
without (or before) executing the statement? For
exa
Hello,
I started with Sqlite just a few days ago and gievn
how simple its api is, I think I am ready to do some
more complex things with it. I am primarily using it
from the tcl api so far.
I have a few questions:
1) If I have a statement that includes "WHERE 0 = 1",
does sqlite optimize the qu
9 matches
Mail list logo
