*argh*
more or less my bad, sqlite3_prepare_v2() instead of sqlite3_prepare()
solved it.
Oyvind.
On Wed, Nov 26, 2008 at 5:29 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Oyvind Idland <[EMAIL PROTECTED]>
> wrote:
> > I am using two prepared statements in my code (that does INSERT),
> > following the pattern
> >
> > prepare(stmt1)
> > prepare(stmt2)
> >
> > while (xx)
> > {
> > bind(stmt1)
> > step(stmt1)
> > reset(stmt1)
> >
> > bind(stmt2)
> > step(stmt2)
> > reset(stmt2)
> > }
> >
> > The first iteration works, but int the second step() fails with code
> > 1.
>
> There's nothing wrong with the pattern. The problem must be in your code
> actually implementing the pattern.
>
> > I am thinking of trying to add both INSERT's inside one statement
> > insted, hopefully that will work better..
>
> That won't work. sqlite3_prepare parses only one statement, up to the
> first semicolon.
>
> Igor Tandetnik
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
