Thanks Tim - but METHOD SET CODE doesn't work in a compiled database, does it?
On 7 March 2017 at 23:40, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I can't see a way to programmatically add a trigger to it > > Triggers can be enabled or disabled via the ALTER TABLE command, > > but how can a trigger be created? Is there ANY way to create a trigger? > > METHOD SET CODE would likely work for you to set the code, something like > this: METHOD SET CODE("[trigger]/table_1";$code) > > The problem I think you will find is how to enable the individual trigger > checkboxes, the ones you normally click in the table properties... > > ALTER TABLE allows you to disable or enable the Trigger mechanism, it does > not allow you to select which triggers are enabled or disabled (i.e. it > doesn’t change the state of the checkboxes on the table properties). > > You need the ability to alter the checkbox state of the triggers at the > table properties level; I am not aware of a feature for this. > > -Tim PENNER > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** -- ************************************************* CatBase - The Database Publishing Solution tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************