שימוש בטריגרים

שלום, VILLEO

להלן הסבר מ-SDK על כל הטריגרים.

PRE-FIELD
Performs operations as the user enters the form column.
CHECK-FIELD
Performs verification checks on a value specified for a form column.
POST-FIELD
Performs operations once form column check is successful.
PRE-LINE
Performs operations/checks as the user enters the line.
PRE-INSERT
Performs verification checks before a record is inserted into the database.
POST-INSERT
Performs operations once a record is successfully inserted.
PRE-UPDATE
Performs verification checks before a record is updated in the database.
POST-UPDATE
Performs operations once a record is successfully updated.
PRE-DELETE
Performs verification checks before a record is deleted from the database.
POST-DELETE
Performs operations once a record is successfully deleted.
PRE-FORM
Performs operations before a form is opened.
POST-FORM
Performs operations when a form is exited, provided there were insertions, updates or deletes in the form.
CHOOSE-FIELD
Creates a list of values from which the user can choose when filling in a specific field (for short lists).
SEARCH-FIELD
Creates a list through which the user can search for the needed value of a given field (for long lists).

הכי טוב לבדיקת תקינות נתונים :
אם לשדה אחד : CHECK_FIELD
אם לשורה : PRE-INSERT – PRE-UPDATE
בטריגרים של POST-XXX ,כבר מתבצעת הכנסת הנתונים לטבלה, ואז הבדיקה כבר לא רלוונטית.
תמיד משתמש טיפש יכול "להרוג" את המסך מטסק מנג'ר.

כפי שכבר אמר לך godmode, בטריגרים של POST אתה נמצא לאחר העדכון. ראה את הסבר שלו.