> -----Original Message-----
> I have tried a stored procedure.
> It work. But I lack response from the server while the rutine runs.

You could easily return status data via an output param, using SUSPEND at
any time within the proc, however, this might be inefficient in terms of
bandwidth/CPU.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage