This operation makes the next events do not run and stop if controls do not provide.
Validation operation at Property Panel
Properties
Description: A description of the action is written.
Heading: Specifies the name in the action list when added as a Form Action.
SQL Query: If the result from the query is 0, all operations are stopped and a warning message is given. If the result is 1, the process continues.
Warning Message: Message information to be given after stopping is written.
Run Condition: If the value in the query entered in this field is ‘0′, the corresponding action will not run.
Request Confirmation: Select whether to ask for confirmation before running the action. If Request Confirmation is activated, the Confirmation Message feature is turned on and the message that will be displayed when requesting confirmation is written.
Example Used
For example;
There is a textbox for the phone in a form. This form has an operation as Before recording and Validation.
Its query contains Case When clause for the control. The result of the query 0 or 1. “0“ as the result means not run that event. Here, the form does not save. “1” as the result means ignoring this control, I mean, it runs that event
E.g. ; if you write two-digit in the numeric box, the warning comes as in below.