Zeoslib Portal

Hi all,
how can I cancel a Zquery, which is opening in an other thread?
The Query opens some quite huge amount of data, which is displayed afterwards in a Grid.
I perform the Zquery.open call inside a separate thread, so my main Form will not be frozen.
But, the user can close this form while the thread is running. I wish to stop the thread and more importantly the Query. Is there any nice way to do it?

Many Thanks
Pawel

Which database are you using? I.E. Using firebird SS (not embedded) should be quite simple

I'm using Postgres 8.3.9. ZeosLib 6.6.6-stable (from 2009-12-30). Delphi 2007.

A solution, not very good, could be:

Add on the uses ZPlainPostgreSqlDriver;

On a procedure
var
PlainDriver: IZPostgreSQLPlainDriver;
begin
...
PlainDriver := IZPostgreSQLPlainDriver(ZConnection1.DbcConnection.GetIZPlainDriver);
PlainDriver.RequestCancel(ZConnection1);
...

thanks, I will try it out

One small thing so far:
GetIZPlainDriver is undeclared identifier.
But I found the proc GetDriver. I suppose that's the one.

I'm using firebird 2.1 ZeosLib 6.5.6-stable delphi 7
thanks for advice.

I think this link and this could help you