Subject Re: [firebird-support] Re: Problem extracting check constraints in FB 2.1.3
Author Milan Babuskov
jegazarco wrote:
> SET TERM ^ ;
> CREATE TRIGGER CHECK_41 FOR SYS_USUARIO_PRUEBA ACTIVE
> BEFORE UPDATE POSITION 0
> check (IDUSUARIO > 0)^
> SET TERM ; ^

Looks like something has messed up your system tables. What does the
following query return?

SELECT a.RDB$SYSTEM_FLAG
FROM RDB$TRIGGERS a
where a.RDB$TRIGGER_NAME = 'CHECK_41';


Try setting the rdb$system_flag manually to 4 and see if that helps.


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================