You need an entirely separate connection and transaction to the database.
See the threads sample application for one way it can be done.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <andymurf2000@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, March 20, 2001 3:48 AM
Subject: [IBO] IBO and background threads


> Hi Guys,
>
> Anyone have any sample Delphi code to use for the following, its way
> over my head!
>
> I wanna do a 'select count(*) from the server to count record no.s in
> large datasets.
>
> I do however want to do this in a different thread so the user can
> get on with sorting out the data and the record count doesnt hold
> things up.
>
> Any ideas?
>
>
> Cheers,
>
> Andy.
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>