On 07/10/2014 08:44 PM, Baptiste Daroussin wrote:
Hi,
We are using sqlite intensively in out developement and we discovered
that apparently we cannot create a statement with a pragma
Is there a reason why it is not possible? is it a bug or a per design
The docs feature the following two points:
* No error messages are generated if an unknown pragma is issued.
Unknown pragmas are simply ignored. This means if there is a typo in a
pragma statement the library does not inform the user of the fact.
* Some pragmas take effect during the SQL compilation stage, not the
execution stage. This means if using the C-language sqlite3_prepare()
<https://www.sqlite.org/c3ref/prepare.html>, sqlite3_step()
<https://www.sqlite.org/c3ref/step.html>, sqlite3_finalize()
<https://www.sqlite.org/c3ref/finalize.html> API (or similar in a
wrapper interface), the pragma may run during the sqlite3_prepare()
<https://www.sqlite.org/c3ref/prepare.html> call, not during the
sqlite3_step() <https://www.sqlite.org/c3ref/step.html> call as normal
SQL statements do. Or the pragma might run during sqlite3_step() just
like normal SQL statements. Whether or not the pragma runs during
sqlite3_prepare() or sqlite3_step() depends on the pragma and on the
specific release of SQLite.
Do either of them explain what you are seeing?
https://www.sqlite.org/pragma.html
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users