Two possibilities I can think of:

1. Make it a selectable procure, returning 1 string;
Give the string a value and suspend.
Do more things
Give the string another value and suspend

2. Use events

egards
John


d_dude_2003 wrote:

> Hi there folks,
>
> I have a long running stored procedure which does
> alot of things. I need to be able to report the status
> of operation to client at certain points...Just a simple string
> message would do...
>
> Any ideas how to implement this?
>
> Thanks.
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>

--
John vd Waeter
mailto:john@...
http://www.jvdw.nl
http://www.shotinthedark.nl