OnModify Trigger

21ahmed

Hi,

I want to block the modification of sales line (All fields), so i added an ERROR message at the OnModify Trigger of the table 37.

The problem that the message appear when i try to change all fields expected the two fields "Type" and "No.".

I want to know why Navision doesn't block for these two fields although they are not included in the primary key of the table. And if you met this problem before, how can i solve this.

Thank you all

Savatage

http://msdn.microsoft.com/en-us/library/dd355319.aspx

We recommend that you do not include code that can stop the user from recording a change in the OnModify trigger on a table. For example, do not include code for displaying error messages. If a user has previously changed the contents of some fields in a record, then these changes must always be accepted by the system.