SQLite Forum

Prepared Statements
I have a number of lengthy queries stored in a table by a unique name. <i>(This removes verbosity/clutter from the calling application)</i>

At runtime, an application requests the execution of a particular statement by name. For this I use the sequence


A given query may or may not require parameters specified at runtime.

1. Is there an API to be called after sqlite_prepare_v2 that indicates  whether I should use the sqlite3_bind_* APIs <i><u>before</u></i> calling sqlite3_step? 
2. And, how many parameters I should expect?

and finally,

3. Is it possible to save a prepared statement and (may be) use it with sqlite3_exec?

<i>(As a workaround, I know that I can add more columns to the table to indicate whether parameters are  required with 0 = none required, n = n parameters required).</i>