chetana bhargav
<bhargav_chetana-/[EMAIL PROTECTED]> wrote:
Just wanted to know can we have multiple quries in a single prepare
statement seperated by semicolons.Something like,
Select count(*) from tbl where name="foo";select count(*) from tbl1
where name = "bar"
sqlite3_prepare will parse a single statement, and return a pointer to
the first character of the next statement. You would need to call it
again to prepare the next statement.
Note also that string literals should be enclosed in single quotes, as
in name = 'foo'. SQLite tolerates double quotes but sometimes this may
lead to surprising effects.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
