Can named parameters be used in the when clause of the CREATE TRIGGER statement or is such combination unsupported?
I'm unable to resolve the index of a parameter by calling sqlite3_bind_parameter_index(stmt, ":VVTEXT") after calling prepare_v2 (successfully) for "CREATE TRIGGER TEST_TRIGGER AFTER INSERT ON TEST_TABLE FOR EACH ROW WHEN NEW.COLUMN_1 = :VVTEXT". It's odd that sqlite3_bind_parameter_count() for the statement does (correctly) return 1, but at the same time the name for the parameter 1 returned by sqlite3_bind_parameter_name() is '(null)'! Resolving the parameter index for other types of SQL statements seems to work just fine. This is for 3.6.11. Thanks, Teemu _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
