Re: V15 and SQL

[Robert McKeever via 4D_Tech]

Unfortunately, adding ‘ALTER DATABASE ENABLE TRIGGERS’ to the server startup 
routine did nothing.

> On Nov 18, 2018, at 9:50 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> could it be possible that triggers are disabled by code?
> 
> http://doc.4d.com/4Dv15/4D/15/ALTER-TABLE-DISABLE-TRIGGERS.300-2048419.en.html
> http://doc.4d.com/4Dv15/4D/15/ALTER-DATABASE-DISABLE-TRIGGERS.300-2048403.en.html
> 
>> 2018/11/15 8:25、Robert McKeever via 4D_Tech <4d_tech@lists.4d.com>のメール:
>> a 4D server (Mac) is receiving new records in a table via SQL. That is fine 
>> EXCEPT that
>> ((Trigger event=On Saving New Record Event) | (Trigger event=On Saving 
>> Existing Record Event))
>> never triggers. I need this to happen so other related tables can be updated 
>> accordingly. Any suggestions?
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: V15 and SQL

[Keisuke Miyako via 4D_Tech]

could it be possible that triggers are disabled by code?

http://doc.4d.com/4Dv15/4D/15/ALTER-TABLE-DISABLE-TRIGGERS.300-2048419.en.html
http://doc.4d.com/4Dv15/4D/15/ALTER-DATABASE-DISABLE-TRIGGERS.300-2048403.en.html

> 2018/11/15 8:25、Robert McKeever via 4D_Tech <4d_tech@lists.4d.com>のメール:
> a 4D server (Mac) is receiving new records in a table via SQL. That is fine 
> EXCEPT that
> ((Trigger event=On Saving New Record Event) | (Trigger event=On Saving 
> Existing Record Event))
> never triggers. I need this to happen so other related tables can be updated 
> accordingly. Any suggestions?




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

V15 and SQL

[Robert McKeever via 4D_Tech]

a 4D server (Mac) is receiving new records in a table via SQL. That is fine 
EXCEPT that 

 ((Trigger event=On Saving New Record Event) | (Trigger event=On Saving 
Existing Record Event))

never triggers. I need this to happen so other related tables can be updated 
accordingly. Any suggestions?

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**