On 2/28/2014 5:48 PM, L. Wood wrote:
Is this legal?
1) Create "INSERT" prepared statement with parameters.
2) Create a second non-parameter "BEGIN TRANSACTION" prepared statement,
execute it with _step(), and finalize it.
3) Attach values to the parameters of the first "INSERT" prepared statement,
_step() it, _reset() it.
Repeat 3) many times.
4) Create a third non-parameter "END TRANSACTION" prepared statement, execute
it with _step(), and finalize it.
5) Finalize the original "INSERT" prepared statement.
Looks perfectly fine to me. That's pretty much the standard operating
procedure.
Could these prepared statements conflict with each other?
I don't see why they would.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
