Subject | Re: [firebird-support] how to |
---|---|
Author | Helen Borrie |
Post date | 2003-11-15T01:42:05Z |
At 01:15 AM 15/11/2003 +0000, you wrote:
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.
>y must declare a store procedura thatcreate procedure delete_garbage
>delete de data stored in a tabel if
>the date of one of the fields (date)
>is 30 dais lower than today.
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.