On 9 Mar 2011, at 21:29, Nick Hodapp wrote:
> Is it possible to duplicate a prepared statement?
Yes, if the original statement used sqlite3_prepare_v2:
DBrc = sqlite3_prepare_v2(db,sqlite3_sql(original),-1,&duplicate,NULL);
> I have a need to run the same query multiple times with different
> parameters. I can't re-use the prepared statement because multiple copies
> of the same query, but with different parameters, are active at the same
> time. That is, I need to step through the results of these queries in step
> with each other, not serially.
Can you not combine them into one über-statement? You would have to if the
statement modified the database.
Best Regards,
Phil Willoughby
--
Managing Director, StrawberryCat Limited
StrawberryCat Limited is registered in England and Wales with Company No.
7234809.
The registered office address of StrawberryCat Limited is:
107 Morgan Le Fay Drive
Eastleigh
SO53 4JH
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
