SQL triggers are deleted when I change the definition of the fields of the table

marpacca

Hi all,

I have some custom triggers in some tables. With Nav2009 version I had no problems, but with Nav2015, when I modify the table from Nav, when I change the size of a field for example, the triggers are deleted.

I've tried it also with Nav2016 and also disappear.

Anyone know why or how could I avoid triggers to be deleted?

The version of SQL that I use is 2014.

Thank you very much

Marcelino

kriki

Yes, don't use them! Let NAV handle that kind of things. Avoid doing something like that directly in SQL. It will come back and byte you.

Use the database-triggers in NAV to do something like this.