I used sqlite version 3.5.9.
The interface sqlite3_next_stmt() is not offerd.
Any other solution to check whether all statements really are finalized?
From: Dan danielk1...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent:
Simon Slavin-2 wrote:
Forget all the fancy ways to speed up individual INSERT commands. You
could probably just use sqlite_exec. Your speed problem is probably
that you're not specifying that they're all the same transaction. Do
a 'BEGIN TRANSACTION' before the first one and a
On 5 Jul 2009, at 2:02pm, Indiff3rence wrote:
Using the v2 version of prepare didn't help. I'm not sure how can I
use
sqlite_exec and 'BEGIN TRANSACTION' / 'COMMIT'. Can you please
provide an
example where you insert multiple entries to a DB.
Do the command 'BEGIN TRANSACTION'. Then
BareFeet wrote:
How can I get just the column headers without all the result rows?
Turn headers on, then perform a search which gives no results.
Unfortunately, the sqlite3 command line tool does not show the headers
when there are no result rows.
You can change
Indiff3rence wrote:
My question is: why is necessary to reset the statement before I can rebind
it?
It should work only if I clear the old bind, no?
You need to reset the statement so that it can be executed again from
the beginning (see section 3.0 of http://www.sqlite.org/cintro.html
a question for the sqlite developers.
The inability of INSERT OR REPLACE to maintain referential integrity
leaves me with no mechanism to implement a feature in my project that
I was intending to provide. Are there any plans to add in the
functionality for INSERT OR REPLACE to call delete