Hi there, I am trying to make a trigger calling a function BEFORE DELETE on a table that contains file names. This function takes the filename of the row to be deleted, removes it and returns undef on failure. I am not too expert of triggers and it can be solved from a script, but that is not a nice design.
Here is my trigger attempt: CREATE TABLE table1 ( a text, b text ); CREATE TRIGGER recall_who BEFORE DELETE ON table1 FOR EACH ROW WHEN NOT recall_delete( table1.a ) BEGIN SELECT RAISE (IGNORE); END; func. remove_file takes one argument, the col.a value of table1; containing the full path of the file. However, I receive this error on the populated table: DBD::SQLite::db do failed: no such column: table1.a at SQLiteTrigger.plx line 35. I would think that I have referred to the table properly... (Called from Perl 5.10 DBD::SQLite, SQLite 3.6.23.1 ) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
