--- In firebird-support@yahoogroups.com, "Luis Semedo Duarte" <CrazyMenConnected@...> wrote:

>
> --- In firebird-support@yahoogroups.com, "Luis Semedo Duarte" <CrazyMenConnected@> wrote:
> >
> > Hello, and thank you for reading this message.
> >
> > I have a question about firebird v2.0 long running queries.
> > Lets say i have to import and manipulate from another database large ammounts of data.
> > Importing and manipulating the records according to my database bussines rules is not an issue, but it does take a lot of time to process it.
> >
> > Is there any way to output status messages back to the user/app? I mean just like MSSQL has RAISERROR() function that allows a message to be delivered without raising an exception.
> >
> > Is there any similar functionality is FB?
> >
> > Thank you for your time!
> > Luis Semedo Duarte
> >
>
>
> Can anyone please help me on this question?
> Thanks!
>
> Luis Semedo Duaret

I also used to work with MSSQL and would occasionally use RAISEERROR within a stored procedure for tracking progress. Firebird has an EVENT functionality that seems like it might provide what you need. At the moment, I am also considering how to deal with long running queries and am considering this as a solution along with a simple pulse component to let the user know that the program has not died.

There is another thread in this group at the moment talking about threads and someone cited an excellent paper on Firebird Events
http://www.firebirdsql.org/doc/whitepapers/events_paper.pdf. That would be worth reading to see if it would be something you could use.