Subject | Re: how to |
---|---|
Author | Luis Adrián Amato |
Post date | 2003-11-15T03:41:22Z |
thanks a lot !!!!!
where can i find this information,
could you tell me about some book
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
where can i find this information,
could you tell me about some book
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> 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.