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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
