Re: Triggers inline in 4gl

nabson@derwent.co.uk wrote: : Does any one know of a way to run DROP/CREATE TRIGGER statements : inline in 4gl code (I'm having to pipe SQL to dbaccess at the moment : which makes error trapping difficult)? :=20 : It would be even more helpful if someone could tell me how to : temporarilly disable triggers via 4gl/SQL. Hi, use PREPARE and EXECUTE commands to do this in I- 4GL. If you are on I-OnLi= ne=20 version greater than 7.10 UD1,=20 you can also disable triggers using SET TRIGGERS {trigger_name | FOR=20 table_name} {DISABLED | ENABLED}=20 command (first prepared and then executed in I-4GL). Regards, Miroslav Lorenc