Dear SQLite,
I am running a sequence of inserts:
BEGIN
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
INSERT INTO table ...
I am catching the 'kill -1' signal (aka CTRL-C) and executing a final query:
COMMIT
When I execute the 'COMMIT' I get:
"library routine called out of sequence"
Every other query command after this returns the same.
My guess is the interrupt is kicking in during SQLite completion of the
previous query. Therefore SQLite is half way through something when
this occurs.
Can any person suggest a possible solution as I am out of options. For
instance, some command to tidy up SQLite so that the next statement does
not fail. Otherwise I loose all my inserted data :)
Regards,
Ben Clewett.
Version 3.1.6