Thanks Markus,

too bad.
do you know, if it's the same with firebird?

Regards,
Jörg

----- Original Message -----
From: "Markus Ostenried" <chef_007@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, February 25, 2002 6:17 PM
Subject: Re: [ib-support] How to detect BLOB changes in a Trigger


At 16:57 Monday, 25.02.2002 +0100, you wrote:
>Hi,
>
>How can I detect if a user has changed a BLOB field?
>I still use Interbase V6.0.0.627.
>
>Regards,
>Jörg

Jörg,

I think you have to use an UDF for this task because you cannot compare
blobs with storedproc/trigger language.

Jason Wharton says in his Replication help file:
>>>
For comparing BLOB columns before deciding whether to replicate them, the
replication module needs a special UDF library to be installed on the
server. It contains the function FN_BLOBS_EQUAL for comparing the contents
of two blobs.
Custom-written by Ann Harrison (IBPhoenix), it is available for both
Windows and Linux servers.
Where to Get the Library
The compiled BlobCompare.dll (for Windows servers) and BlobCompare.so (for
Linux) are included with this help kit.
Registered IBO users can download kits containing the libraries and C
source code from the normal Registration Site URL.
© 2001 Jason Wharton and Computer Programming Solutions.
<<<

I don't know if this udf dll is available only for registered users of
IBObjects (www.IBObjects.com) or if it can be downloaded from other sites,
too.

HTH,
Markus