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
