Christian G�tter wrote:

>Hi Lester,
>
>
>
>>Stored Procedures are a bit more complex but you asked about triggers :)
>>
>>
>
>some of my triggers are as complex as SPs ;-)
>
>
>
>>The select is just a select statement, which needs to produce the
>>correct results and a lot of the sorts of things done in the DO
>>statement can now be done with CASE or checking in stages by trying each
>>bit. In most cases all they are are convenient ways of doing what you
>>can do in simple SQL anyway.
>>
>>
>
>
>
>>IB_SQL will only load valid code, and starting with the basic core and
>>adding each step is not difficult. Just don't throw everything at it and
>>expect it to work ;)
>>
>>
>
>You are right - it is possible to "emulate" some PSQL stuff in IB_SQL
>to test it.
>
>But when the PSQL gets rather complex, it is (IMHO) too cumbersome to
>translate all of it to SQL to test it.
>
>With "debugging", I also meant such goodies like breakpoints,
>step-by-step execution, watches and so on.
>
>But there seems to be no tool which can do this with triggers.
>To me, the only way seems to be to translate the trigger into a stored
>procedure.
>

Why, do you know of a tool that can do that for SPs?

Jonathan Neve.


[Non-text portions of this message have been removed]