Hi all
I have several tempfiles I like to delete
with a simple systemcall like system("$rm -rf
$tempfile")
is this possible in a simple trigger:
CREATE TABLE extracted (
instancefile text,
appendfile text,
id integer,
extracted integer,
pmval_sample text,
pmval_align text,
pmval_starttime text,
pmval_endtime text,
nsamples text,
datetime date,
PRIMARY KEY (instancefile),
UNIQUE (id)
)",
" CREATE TRIGGER delete_extracted_from_instance DELETE
ON instance
BEGIN
delete from extracted where id=old.id;
END
