1. Can a use the expression 'WHERE b IN (SELECT ...)' if b is a blob column? Does the 'IN' comparison work with blobs?
2. How "static" does data have to be to be bound with SQLITE_STATIC? If it won't change until the call to sqlite3_step, is that enough? How about until sqlite3_reset or sqlite3_clear_bindings? If all of those are not enough, I assume that if it doesn't change before the sqlite3_finalize, it must be safe to use SQLITE_STATIC? -- Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users