In my database I do lots of inserts, of exactly the same nature so I use a prepared statement, which I cache, always reseting after use. Works fine.
Now I decide that I want a second type of insert, so I try to use a prepared statement for that as well. However it always fails. As long as the other prepared statement is hanging round I can't prepare a new one. Does this seem right or am I really soing something wrong? Can I not have multiple prepared statements created? Regards. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

