Subject Re: [IBO] IBOQuery.OnFilter: BLOB is always empty
Author Helen Borrie
At 11:29 AM 20/06/2005 +0000, you wrote:
>I need to check a text BLOB field in the IBOQuery.OnFilter event, but
>the DataSet.FieldByName('MyBlob').AsString is always empty in this event.
>But if I add a SUBSTRING on the same BLOB in the query, then
>DataSet.FieldByName('MyBlobText').AsString is available in the OnFilter:
> , SUBSTRING( MyBlob FROM 1 FOR 1500) AS MyBlobText
>This solution is not the best. Is there another way to know the
>content of a BLOB in the OnFilter.Event ?

Is there a special reason why you need to use OnFilterRecord for your
test? Generally, it will conflict with the Filter property and cause the
dataset to be empty.

If possible, use the Dataset.Filter property and apply a proper SQL search
criterion, e.g.
MyBlobText CONTAINING 'MyFilterCriterion'