Add support for DDL triggers

[arvanus]

Relates to #48
Add support for DDL triggers, example:

SET TERM ^ ;
create trigger trig_ddl_sp before CREATE PROCEDURE
as
begin
end!
SET TERM ; ^

Get extracted as

SET TERM ^ ;
CREATE OR ALTER TRIGGER TRIG_DDL_SP ACTIVE
AFTER  OR UPDATE POSITION 0
as
begin
end^
SET TERM ; ^

Needs to get RDB$TRIGGERS.RDB$TRIGGER_TYPE complete documentation to fix

flamerobin/src/metadata/trigger.cpp

Line 45 in 01ff896

Trigger::FiringTime Trigger::getFiringTime(int type)

And:

flamerobin/src/metadata/trigger.cpp

Line 207 in 01ff896

wxString Trigger::getAlterSql()

And who knows where else 👍

[Jdochoa]

This task is very complex, because rdb$types not defined this rdb$trigger_type.
I'm separated DB Trigger, DDL Trigger and Trigger, but can't generate script for DDL Trigger.
See https://github.com/Jdochoa/flamerobin/tree/FB3

[arvanus]

Yeah, I could't find any docs about it, maybe ask at https://groups.google.com/g/firebird-support
Good to see you here @Jdochoa!
I'm doing some bug-hunting here, soon I'll push some new patches and a new feature like #69

[Jdochoa]

Yeah, I could't find any docs about it, maybe ask at https://groups.google.com/g/firebird-support
Good to see you here @Jdochoa!
I'm doing some bug-hunting here, soon I'll push some new patches and a new feature like #69

Hi @arvanus you need see
https://github.com/FirebirdSQL/firebird/blob/2964fdd6349134030580dd35ae970c16d34e76e1/src/isql/show.epp#L314-L345
to complete this.

[luronumen]

Hi @arvanus,

Is this issue still reproducible in 0.9.3.8 Snapshot version?

[arvanus]

It's working now