Hi Again
Sorry, the mouse moved and I pressed enter outside the
text-entryfield so it got sent in an unfinished state:
Here is the finished message:
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:
Can we call syscalls from inside sqllite schemas?
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_files_extracted
DELETE ON extracted
BEGIN
--How does this work?
--system("rm -f instancefile");
--system("rm -f appendfile");
END
instancefile holds a path like
/usr/tmp/mortenb/network.interface.in.bytes/eth1
I want that file removed anlong with the tableentry
Thanks
--
Morten Bj�rnsvik
