Subject RE: [IBO] FTS Bugs?
Author John Tomaselli
1) I was just evaluating the product to see if it was a candidate to replace
Rubicon in some applications.
2) The documentation does not mention any restriction as to the use of Blob
SUB_TYPE 1 and thus I feel that the doc be amended or the product create the
triggers with a note about problem.

-----Original Message-----
From: Helen Borrie (TeamIBO) [mailto:helebor@...]
Sent: Thursday, February 07, 2002 10:25 PM
Subject: Re: [IBO] FTS Bugs?

At 11:00 AM 08-02-02 +1100, Geoff wrote:

>Since you are using a blob column I suggest that there are only two
> 1. alter the trigger to use an appropriate UDF (there is a blob
> comparison UDF on the IBO download site)

In fact, that UDF compares two blobs, not a blob with a string. You would
need to have your trigger create a "blank string blob" first before passing
the two blobs to BlobCompare(). This would be relatively easy with
Firebird, which can accept a string as input to a text blob, and impossible
in any other version.

There are blob UDFs in FreeUDFLib, but make sure that you get the version
from Claudio's site ( as the original version is buggy.

> 2. alter the triggers so that it does not check for blank strings

Unless you have some forced reason to store a blank string in a blob, i.e. a
NOT NULL constraint on a blob column and your app pushing through a blank
blob as a default, then your trigger can simply ignore null blobs. Even so,
under some conditions, I suppose, you would still need to check for a blank
blob if your application code doesn't prevent the user from storing them.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to