I’ve got a similar issue. I user user_version to store a .net version object I’ve serialised as an int. I convert them to/from text to get them in and out using the pragma. It would be a nice to have for pragmas to support parameters.
Cheers On Tue, 11 Jun 2019 at 14:43, Wout Mertens <wout.mert...@gmail.com> wrote: > Hi, > > I am using the user_version pragma for implementing an event-handling > database. I'd like to prepare the statement to update it, e.g. `PRAGMA > user_version = ?`. > > However, sqlite3 won't let me do that, so I just run the text query every > time with the number embedded. > > Not a huge problem, more of a surprise. Would be nice if it worked. > > Wout. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users