At 09:47 AM 2/10/2010, Michael Ludwig wrote:

>vladman992000 schrieb am 21.09.2010 um 12:01 (-0000):
>
>> Does Firebird allow for the calling of stored procedures to return
>> values in a Trigger, or do I have to enclose the entire logic of the
>> SP into the trigger itself in order for this to work?
>
>An interesting question, which I'm just bumping here as it has remained
>unanswered.

You chose a bad week! with two Firebird conferences on and people in transit between their homes and one or both conferences..

Study the PSQL section of the v.2.0.6 release notes for the answer on this.

>Does Firebird have something like MSSQL PRINT to help in debugging procs
>and trigs?

No. Some third-party tools have "debugger" utilities that execute PSQL code in a sandbox (without touching the database itself). I haven't used them so couldn't say how they simulate run-time logic where an answer depends on a real result from the database.

./heLen