Hello drh, I always assume the prepared statement were transitory. I typically create them in a function, use them than delete them. Is there a discussion of their life span somewhere? I typically have DB's that never change schema after their initial creation. How reliable is it to say, create the prepared statement in a constructor and use them for the life of the class?
C Saturday, February 18, 2006, 11:39:10 AM, you wrote: dhc> SanjayK <[EMAIL PROTECTED]> wrote: >> I am puzzled as to why the prepared >> statements should be affected if an unrelated new table is created. >> dhc> SQLite has no way of knowing that the table you created, modified, dhc> or dropped does not effect existing prepared statement - no way dhc> that is other than preparing them again and comparing the results. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> -- Best regards, Teg mailto:[EMAIL PROTECTED]
