Subject | Re: [firebird-support] Re: Problem extracting check constraints in FB 2.1.3 |
---|---|
Author | Milan Babuskov |
Post date | 2009-12-21T22:51:32Z |
jegazarco wrote:
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
==================================
> SET TERM ^ ;Looks like something has messed up your system tables. What does the
> CREATE TRIGGER CHECK_41 FOR SYS_USUARIO_PRUEBA ACTIVE
> BEFORE UPDATE POSITION 0
> check (IDUSUARIO > 0)^
> SET TERM ; ^
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
==================================