The database was designed many moons back, so I haven't changed that. Do you
think it could possibly cause a problem?

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
Behalf Of Alan McDonald
Sent: 04 July 2006 12:48
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IBO components in a thread

> I've noticed a strange thing while trying to find this problem:
>
> The point of failure is definitely when I'm trying to read a text
> blob from
> the database. However, it happens on seemingly random records and
> sometimes
> the loop runs through all the records without a problem.
>
> Here are some more details:
> The blob field is defined as a domain, such as this:
> CREATE DOMAIN "XML_BLOB" AS BLOB SUB_TYPE TEXT SEGMENT SIZE 400;

why are you fooling around with segment size?
try the default 80
Alan

>
> The blobs contains XML data of around 6KB in size. I access the
> blob using a
> simple statement such as this:
> XMLStr := MyTable.FieldByName(SOME_XML_FIELD').AsString;
>
> I sit in a loop, reading the blob data from the result set.
> XMLStr is simply
> a string value. The statement above causes three random problems.
> Sometimes
> it gives an "error reading connection" type error, sometimes it gives an
> "invalid BLOB handle" error, and sometimes it simply hangs dead on the
> statement as if something is sitting in a tight loop. Very weird indeed!
>
> I actually do have other IBO components on the DataModule: They are: 1)
> TB_SessionProps and 2) TIB_Events. I don't know if any of these two

could

> perhaps cause a problem?
>
> Regards,
> Don

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