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
**********************************************************************
