SQLite Forum

Prepared Statements
Login
> A given query may or may not require parameters specified at runtime.

 > - Is there an API to be called after sqlite_prepare_v2 that indicates whether I should use the sqlite3_bind_* APIs before calling sqlite3_step?  
 > - And, how many parameters I should expect?

<https://sqlite.org/c3ref/bind_parameter_count.html>

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

No.