On Thu, Mar 10, 2011 at 11:33:28AM +0000, Philip Graham Willoughby scratched on the wall: > 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); This doesn't duplicate the existing statement data structure, it simply prepares a new statement using the same SQL command string. This is what the OP was trying to avoid. However, as far as I know, multiple prepares are the only way to get multiple statements. This isn't a bad technique for making sure you get the exact same statement. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
