This operation makes controls update for its view or new data.
Update Value operation at Property Panel
A type of operation that allows the information in the form control to be added to the form to update itself, the entire form, or a different form control based on a change in the relevant field. Since SQL queries want to get the information of a field in the form, the field name can be taken directly without writing the select clause and the value of the field can be retrieved without going to SQL by writing $P.
A list or its other types, a graphic, a calendar, a graphic line, and a map controls must be updated to see on the Client screen. Generally, this operation is used with When the form is opened event.
Description: A description of the action is written.
Heading: Specifies the name in the action list when added as a Form Action.
Value Area: The field to be updated is selected from itself, All Form, or related form fields.
SQL Query: With the SQL query written in this field, the data from the query is written to the related element or elements specified in the value field.
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.
You have a list of control. This list’s query is written in the properties of it. If you want to view the Client screen, you can add an operation to the form. When the form is opened and Update Value operation is added for the List view. But, the SQL Query of the operation is not written because of the query of the List.
The operation on the form for the List
You have a numeric box and product named textbox. If you want to change the Product area according to the numeric box value, you can add an operation, that is Update Value with When the value changes, for this scenario. SQL Query of this operation can be as in below for the control, which is a textbox containing the product, in Value Area.
When you change the value in the Serial number, the Product will changes.
Client view on screen for the result of this operation