OnModify trigger

nt · 2006-06-29

hi all,

can i change a record and skip the OnModify trigger?

thanks.

kriki · 2006-06-29

Yes, you can use MODIFY(FALSE); instead of MODIFY(TRUE);

If you want to do it in a form, you need to put some code in the "Form - OnModifyRecord()"-trigger:

MODIFY(FALSE); // you write the record yourself, without using the triggers
EXIT(FALSE); // you tell Navision NOT to modify the record (you just did it yourself)

nt · 2006-06-29

thanks

nt · 2006-06-29

can i do that just for one field?

kriki · 2006-06-29

nt wrote:

can i do that just for one field?

What do you mean with this?

kine · 2006-06-29

No, because what you want to do if you change two fields and after that you will "save" the record? (by moving to another...)

DenSter · 2006-06-29

The OnModify trigger fires off when a modified record is written to the database, not for individual fields.

nt · 2006-06-29

i want only save the record if i change a fied a particulary field. all the other i dont want permit to change.

David_Cox · 2006-06-29

Check the Rec.MyField value against the xrec.MyField value in the on modify trigger, if the code is in a code unit then there is no xrec so store the original record and compare the field to the changed record.

OnModify()
// Test the primary key fields match and if changed
IF (rec."No." <> xrec."No.") OR (rec.MyField = xrec.MyField)THEN
EXIT;

Why not just create a limited entry new form for the users you want to lock out of changing these fields, make this the default and the original form run from setup?

DenSter · 2006-06-29

Which still saves the record, it just skips the rest of the OnModify code. If you want to prevent the record from being saved, you do ERROR instead of EXIT.

nt · 2006-06-29

in that way all the editable fields can be modify.

David_Cox · 2006-06-29

Ok then on after get record, store the record in a variable, on modify check the field against the variable, if the field has changed update and modify the variable, and EXIT(FALSE) the OnModify form trigger

Form - OnAfterGetRecord()
OldRec.GET("No.");

Form - OnModifyRecord() : Boolean
IF OldRec.MyField <> MyField THEN BEGIN
OldRec.MyField := MyField; // Update only the one field
OldRec.MODIFY;
END;

Rec := Oldrec;

EXIT(FALSE); // This is all you need not to commit the changes

nt · 2006-06-29

ok thanks for all.

OnModify trigger

Comments

Categories