The second point seems to explain my problems thanks you
2014-07-10 18:05 GMT+02:00 Dan Kennedy <danielk1...@gmail.com>: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users