Re: URGENT: Automate an update

it doesn't help because I am not updating it manually

Abhijith wrote:

> write an on update trigger
>
> Kalle wrote:
> > Hi all,
> >
> > I need help in order to create a following "mechanism".
> >
> > I have a table where is a column called window_open and it has two
> > values 'Y' and 'N'
> >
> > Now I need to automate the update a single row based on following rules:
> >
> > If time is between 08:00-16:00 the value on that window_open column
> > should be 'Y' during other period the value should be 'N'. How can I do
> > this and automate the task...
> >
> > Thanks in advance,
> >
> >
Received on Wed Jul 02 2003 - 05:19:40 CDT