err - anyone done a UDF for this??

Regards

Roger P
-----Original Message-----
From: Ivan Prenosil [mailto:prenosil@...]
Sent: 04 December 2002 10:25
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] trigger on a blob field

> From: Thomas Steinmaurer <ts@...>
> According to a logging trigger created by IBLM ;-), NULL values
> must be considered separately.
>
> An general example:
>
> if (((OLD.COLUMN IS NULL) AND (NEW.COLUMN IS NOT NULL)) OR
> ((OLD.COLUMN IS NOT NULL) AND (NEW.COLUMN IS NULL)) OR
> (OLD.COLUMN <> NEW.COLUMN)) THEN
> ...
>
> Be aware, that BLOB column values can't be compared by using
> the OLD and NEW context variables. You'll have to use a UDF
> for this.

- Firebird allows direct comparison of blobs (but separate testing
of nulls is still needed)

- using UDF should work for both IB/FB, and Null state of blob
column can be tested directly in UDF

Ivan
http://www.volny.cz/iprenosil/interbase


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]