Hi,
according to documentation,
"An application is allows to prepare multiple SQL statements in advance and
evaluate them as needed. There is no arbitrary
limit to the number of outstanding prepared statements."
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. I
have also double-checked that I
give the correct statement objects etc. Commenting out one of them works.
I running 3.6.6.1 on WinXP.
I am thinking of trying to add both INSERT's inside one statement insted,
hopefully that will work better..
-Oyvind
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
