On Tue, Sep 7, 2010 at 17:55, W O <sistemas2000profesional@...> wrote:

> Hello Markus
>
> Thank you very much for your answer.
>
> How can I use an UDF to show a MessageBox? can you give some example?
>
> How can I use a logging table? can you give me some example?

Writing UDF libraries isn't trivial, so it would be best to use an
existing one. I don't know if rfunc works with the current version of
Firebird but you could give it a try:
http://rfunc.sourceforge.net/
If you look under "Manual" you will see that it has a function
"MsgBox" which should do what you want.

When I wrote about "logging table" I meant something as simple as
create a table called LOG with one VARCHAR(500) column and insert
whatever messages you need for debugging.
Like INSERT INTO LOG (TEXTCOLUM) VALUES ('begin of trigger');

HTH,
markus