>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
Nanotr
>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 throug
>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
Marc L. Allen wrote:
> Oh.. you're positing a second party. Ok.. now I'm interested to see if there
> was one.
Not necessarily. "Someone" includes the program that prepared the statement.
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@
ite-users@sqlite.org
> Subject: Re: [sqlite] Not sure how to interrupt this
>
> 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
&g
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()
>
> Database file was created on
rg
Subject: Re: [sqlite] Not sure how to interrupt this
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-
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-users@sqlite.org
http://sqlite.org:8
>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
Nan
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
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)
> message: statement a
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 wrote:
> I am getting back SQLITE_DONE (101) from sqlite3_step() and the
> sta
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 [Scans](ScanID, Timestamp
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 N
14 matches
Mail list logo