This operation adds the missing rows to the list according to the fields from the SQL query that are matched according to the ID field of the connected list and updates the rows in the list. It deletes the rows with ID information minus the value from the list.
Update List operation at Property Panel
Properties
Description: Description related to action is written.
ID Field: The name of the ID field in the list is written.
SQL Query: The SQL query is written
Linked List: Linked List is chosen from this area.
Run Condition: If the value in the query entered in this field is “0”, the corresponding action will not run.
Request Confirmation: Select if the request confirmation will be used 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 are a few controls in a form.
A record is deleted from the form.
There is a list in another form for this table. The record in the middle of the list is deleted from the table. This list needs to be updated.
A button is added in the form. The button has an Update List operation with When clicked event. ID Area represents the list query’s ID. The list query is written in the SQL Query area. Then, Linked List is chosen.
When the button is clicked, the list is updated as below.
