Since setting certain pragmas may affect the SQL code generated from a
statement during sqlite3_prepare(), it is a good idea to have currently
prepared statements re-prepared via the expire opcode.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqli
Wout Mertens wrote:
> 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.
<
I suspect this doesn't happen because from an in-expert bit of poking,
I don't think PRAGMA commands "really" get compiled to VDBE (which is
what I believe "preparing" a statement does).
In the transcript below, although the _query_ seems to use VDBE (to
return the result in "p4", the two attempts
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 wrote:
> H
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
Thank you.
Mark
On Monday, June 10, 2019 12:53:29 PM Luuk wrote:
> On 10-6-2019 05:08, Mark Halegua wrote:
> > On Monday, June 10, 2019 03:46:02 AM Simon Slavin wrote:
> >> On 10 Jun 2019, at 3:44am, Mark Halegua
wrote:
> >>> I probably should figure this out, but in a GUI, how do I recover a
6 matches
Mail list logo