You cannot send a message to user from a stored procedure. The only thing
you can is throwing exception (and user can see the exception text), but
your transaction is rolled back after that. You can read the excellent TI
sheet Handling errors (I do not remember the name of this document exactly,
but you can find it on the www.ibobjects.com) from Helen. There are
described the issues concerning exceptions in triggers and procedures very
clearly.
Ales

> -----Original Message-----
> From: arnofab2002 [mailto:arnofab@...]
> Sent: Tuesday, July 09, 2002 9:51 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Info mesage from a procedure
>
>
> Hi All.
>
> I have a simple question:
>
> How to send to client a message of information from a stored
> procedure or a trigger?
>
> IE: ShowMessage('Do something...')
>
> TIA
> Arnaldo
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/TPvn8A/PfREAA/Ey.GAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/