Sorry to be such a pain, but here is something even weirder. When I put a
50ms Sleep into my loop, then it seems to run fine and I can get the data
from the result set without a hitch. Unfortunately this is not acceptable as
literally thousands of records need to be loaded and it takes way too long
now. I'm starting to wonder whether I shouldn't start looking at upgrading
my version of IBO. However, it's been running extremely well so it won't
help upgrading if a newer version doesn't fix the problem.

Regards,
Don Schoeman



-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
Behalf Of Don Schoeman
Sent: 04 July 2006 13:56
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IBO components in a thread


Just another note, I've created the same routine which loads the data in a
standard Delphi app and it works flawlessly, so it must have something to
do
with the threads.

Regards,
Don Schoeman

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
Behalf Of Don Schoeman
Sent: 04 July 2006 13:03
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IBO components in a thread

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]

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






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