onBeforeUpdateAll

View video

This event occurs after clicking the Save button on the multi-record form. The form will then execute the events onValidate and onValidateSuccess, and then execute the event onBeforeUpdateAll before starting the execution of SQL commands to update records in the database.

Note: This event is triggered only once, regardless of the amount of rows updated in one click on the Save button.

As examples we can see in the example below, we consult a user privileges table before updating the record, if it does not have such privilege, we send an error message.

sc_lookup(priv_upd ," select priv_upd from tb_privileges where login = [var_login] ");

if({priv_upd [0][0]} != 'YES'){

sc_error_message(" you do not have privileges to perform this operation ");

}