> This may seem like a very naive question, but is it possible to edit > the SQL of a trigger from within a programming language (Delphi, in > my case).
> I use IBX components (I know this is not supported, but it seems to > work fine!), and I want to periodically update the date condition on > one of the triggers, but cannot work out how to do it / if it is > possible. Junk, you can execute and commit the entire ALTER TRIGGER statement. It is not easily possible to just alter the SQL body of the trigger. However, frquently changing DDL elements doesn't generally sound like a good idea to me. You should also consider another solution. Maybe you can store the date in a table so the trigger can read this and work with the date from the table. And you can change the date with a simple UPDATE statement. Regards Stefan -- Stefan Heymann, Tübingen, Germany
