Subject | Re: Disable updates based on field value |
---|---|
Author | radevojvodic |
Post date | 2005-03-04T07:56:10Z |
Thanks Ann,
I think that will solve my problem. I just thought that there is a
simpler way.
P.S.
When can we expect Firebird 2? I'm not very familiar with what is
going on with new development of firebird. Where can i find more
information on future releases (schedule etc.)
Rade
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
I think that will solve my problem. I just thought that there is a
simpler way.
P.S.
When can we expect Firebird 2? I'm not very familiar with what is
going on with new development of firebird. Where can i find more
information on future releases (schedule etc.)
Rade
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
> radevojvodic wrote:that
> >
> > Thanks Ibrahim,
> >
> > That will probably work. The only problem with that solution is
> > end-user will complete his task and the value wouldn't changewhich
>
> In V2, there's a new comparison operator IS [NOT] DISTINCT FROM
> does exactly what you want. Until then, you have to use...
>
> if (f2 is not null) and
> (old.f3 <> new.f3) or
> (old.f3 is null and new.f3 is not null) or
> (old.f3 is not null and new.f3 is null) or
> (old.f4 <> new.f4) or
> (old.f4 is null and new.f4 is not null) or
> (old.f4 is not null and new.f4 is null)
> exception...
>
>
> Regards,
>
>
> An