Subject Re: [firebird-support] how to
Author Helen Borrie
At 01:15 AM 15/11/2003 +0000, you wrote:
>y must declare a store procedura that
>delete de data stored in a tabel if
>the date of one of the fields (date)
>is 30 dais lower than today.

create procedure delete_garbage
as
begin
delete from atable
where date_field = current_date - 30;
end

You don't need a SP for this, if there are no other tasks to do.

h.