[sqlite] Not sure how to interrupt this

2012-06-29 Thread Jeff Archer
>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >My guess is that a) you have prepared your statement with sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... Statement was prepared with sqlite3_prepare16_v2() Database file was created only moments earlier. Jeff Archer

[sqlite] Not sure how to interrupt this

2012-06-29 Thread Jeff Archer
>Marc L. Allen mlallen at outsitenetworks.com Thu Jun 28 09:31:40 EDT 2012 >I think he wants to know why he is receiving what appears to be an error notification via the callback. >Adam DeVita adevita at verifeye.com Thu Jun 28 09:04:44 EDT 2012 >What is the problem? Yes, the error message

[sqlite] Not sure how to interrupt this

2012-06-28 Thread Jeff Archer
>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:57:06 EDT 2012 >Did you prepare the INSERT statement in between running CREATE TABLE and CREATE INDEX, >by any chance? Or perhaps CREATE TABLE for a different table? No, the CREATE INDEXs were done right after the CREATE TABLE. I have a wrapper

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Pavel Ivanov
9:55 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Not sure how to interrupt this > > Marc L. Allen <mlal...@outsitenetworks.com> wrote: >> How could the schema have changed? > > Someone ran CREATE TABLE or VACUUM or similar on the database (possi

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Igor Tandetnik
Jeff Archer wrote: >> Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >> My guess is that a) you have prepared your statement with > sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... > > > Statement was prepared with sqlite3_prepare16_v2() > >

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Marc L. Allen
: Re: [sqlite] Not sure how to interrupt this Marc L. Allen <mlal...@outsitenetworks.com> wrote: > How could the schema have changed? Someone ran CREATE TABLE or VACUUM or similar on the database (possibly via a different connection). -- Igor

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Igor Tandetnik
Marc L. Allen wrote: > How could the schema have changed? Someone ran CREATE TABLE or VACUUM or similar on the database (possibly via a different connection). -- Igor Tandetnik ___ sqlite-users mailing list

[sqlite] Not sure how to interrupt this

2012-06-28 Thread Jeff Archer
>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >My guess is that a) you have prepared your statement with sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... Statement was prepared with sqlite3_prepare16_v2() Database file was created only moments earlier. Jeff Archer

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Marc L. Allen
How could the schema have changed? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Thursday, June 28, 2012 9:38 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Not sure how to interrupt this Jeff

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Igor Tandetnik
Jeff Archer wrote: > I have SQLITE_CONFIG_LOG callback installed: > sqlite3_config(SQLITE_CONFIG_LOG, cb_sqlite_config_log, /*pUserData*/NULL); > > I get the following message through the SQLITE_CONFIG_LOG callback during > the sqlite3_step(): > errcode: SQLITE_SCHEMA (17) >

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Marc L. Allen
of SQLite Database Subject: Re: [sqlite] Not sure how to interrupt this SQLITE DONE is what you get when you successfully run an insert. What is the problem? Adam On Wed, Jun 27, 2012 at 7:02 PM, Jeff Archer <jarch...@yahoo.com> wrote: > I am getting back SQLITE_DONE (101) from sql

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Adam DeVita
SQLITE DONE is what you get when you successfully run an insert. What is the problem? Adam On Wed, Jun 27, 2012 at 7:02 PM, Jeff Archer wrote: > I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement > is clearly being executed. > > SQL: "INSERT INTO

[sqlite] Not sure how to interrupt this

2012-06-27 Thread Jeff Archer
I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement is clearly being executed. SQL: "INSERT INTO [Scans](ScanID, Timestamp, EndTime, Result) VALUES(NULL, @Timestamp, @Timestamp, @Result);" The table has been created as: CREATE TABLE [Scans] (ScanID INTEGER NOT