ibich" <j...@kreibi.ch>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Monday, November 16, 2009 4:54 PM
Subject: Re: [sqlite] Fine-grainy error report needed
> On Mon, Nov 16, 2009 at 11:32:59AM +0100, A.J.Millan scratched on the
> wall:
-
From: "Igor Tandetnik" <itandet...@mvps.org>
To: <sqlite-users@sqlite.org>
Sent: Monday, November 16, 2009 3:29 PM
Subject: Re: [sqlite] Fine-grainy error report needed
> A.J.Millan wrote:
>> Supposing a dBase without constraints (some like this but not
On Mon, Nov 16, 2009 at 11:32:59AM +0100, A.J.Millan scratched on the wall:
> Martin:
>
> Thanks for the imput. In fact, afther some years using SQLite I'v spent
> almos a weekend because don't remember that the index in the
> sqlite_column_xxx(sqlite3_stmt*, iCol ) where I read the data from
A.J.Millan wrote:
> Supposing a dBase without constraints (some like this but not limited to
> it):
>
> CREATE TABLE tbl (Id INTEGER PRIMARY KEY, Nm INTEGER, Cl INTEGER, Dc REAL,
> Dm REAL, St INTEGER);
>
> A query to poblate:
>
> "INSERT INTO tbl (id,nm,cl,dc,dm,st) VALUES (?,?,?,?,?,?)"
>
>
sqlite-users@sqlite.org>
Sent: Monday, November 16, 2009 11:32 AM
Subject: Re: [sqlite] Fine-grainy error report needed
>
> Any way, the question remains, and the method proposed by Owen perhaps is
> good for debug, but not as a standard method.
>
> A.J. Millan
>
__
"Martin Engelschalk" <engelsch...@codeswift.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Monday, November 16, 2009 10:52 AM
Subject: Re: [sqlite] Fine-grainy error report needed
> Hi,
>
> First, the index of the bind variable (
On Behalf Of A.J.Millan
Sent: Monday, November 16, 2009 9:41 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Fine-grainy error report needed
Hi list:
Supposing a dBase without constraints (some like this but not limited to
it):
CREATE TABLE tbl (Id INTEGER PRIMARY KEY, Nm INTEGER, Cl INTEGER, Dc
Hi,
First, the index of the bind variable (second parameter to
sqlite3_bind_, your 'i') must begin with 1, and not 0, see
http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob
Sqlite does not use strong typing, which means that you can put any data
into any column.
However INTERGER
Hi list:
Supposing a dBase without constraints (some like this but not limited to
it):
CREATE TABLE tbl (Id INTEGER PRIMARY KEY, Nm INTEGER, Cl INTEGER, Dc REAL,
Dm REAL, St INTEGER);
A query to poblate:
"INSERT INTO tbl (id,nm,cl,dc,dm,st) VALUES (?,?,?,?,?,?)"
Then six binds (i = 0 to 5):
9 matches
Mail list logo