Got it. Thanks a million
- Uma
John Stanton [EMAIL PROTECTED] wrote: The prepare creates a virtual machine
which can be rused. A useful way
to implement Sqlite is to use prepare to compile all the SQL in the
initialization phase of the program and then to execute the virutal
machines using
In SQLite3 one uses prepare/step to execute query. The question that I have is,
when your stepping yields no more rows, and one has to re-execute the query,
does one have to call the prepare statement again. If that's the case, what's
the advantage of pre-compiling. If not, how does Sqlite3
Hi,
Uma Krishnan wrote:
In SQLite3 one uses prepare/step to execute query. The question that I have is,
when your stepping yields no more rows, and one has to re-execute the query,
does one have to call the prepare statement again. If that's the case, what's
the advantage of pre-compiling.
The prepare creates a virtual machine which can be rused. A useful way
to implement Sqlite is to use prepare to compile all the SQL in the
initialization phase of the program and then to execute the virutal
machines using step.
By compiling a SQL in advance you can ensure that the program