Re: Triggers or not triggers ?

Posted in 1999

Pons Roca, Isidre — Thu, 28 Oct 1999 13:18:53 +0200 — source: Informix-list mailing list archive (1991-1998)

En Andreas Kumpf va escriure el dia 28 Oct 99, a les 10:58: > Hi, > I've got the problem that there is no flag that show the state of > triggers (enabled or disabled!). Has anyone an idea? Thanks > Query the table SYSOBJSTATE to show the triggers state. (Select * from sysobjstate where objtype = "T") --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------