This operation opens a list window for the table with SQL Query. It is the operation that provides the information recorded in the form of control with the help of the action types added to the form.
Open Form List operation at Property Panel
Properties
Condition: Specifies how to open the new form. In the Same Tab; opens in the main form screen, in the New Tab; opens in a different window on the same screen, in the New Window; pop up on a different screen.
Description: A description of the action is written.
List Heading: This is the field where the title of the list is opened.
Value Area: The value fields in which the listed data will be loaded are selected. When double-clicking the list, the related data is loaded into this area.
SQL Query: The data to be listed is written to the SQL query.
Color Style (Field|Criteria|Value|Type|Colors|Cell (0-1)): The specified color is applied to the line according to the specified area information. For example; Quantity | == | 0 | 0 | Red style will be colored in red with lines 0, or Quantity | == | 0 | 1 | Red will be colored in red with red background
Selection Filter (Field|Criteria|Value): Prevents adding rows to the grid or list according to the specified field and value information. For example; With Quantity |! = | 0 filter, you cannot select from the list for records with quantity 0.
List Value Field: After making a selection from the list, the information about which field in the list will be taken is written.
List-ID Field: The ID information on the main form matches the ID information of the list to be opened.
List Type Field: The form type information on the main form matches the form type information of the list to be opened.
Text Size: Edit the text size of the form to be opened.
Mapping: The list on the form is matched with the field information of the form to be opened.
Closing Action: When the opened form is closed, the action in the form is selected for the operation to be performed.
Fullscreen: Select whether to open the linked form in full screen.
Paging: Open Form Parametrically pages for lists opened with list action.
Record Selection List: Used to open lists faster. The drop-down form can only be used for lists with record selection
Line Looking: Allows to navigate the lines.
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
Add a button after editing the areas on the Studio screen. Add an event to this button. Select Open Form List as operation. Edit this operation properties.
Properties of Open Form List
When the related button is clicked after adding data in the Client screen, the following screen will open in the new window according to the properties of this operation. Add button on the right makes the related data fill the Client screen. (Double-clicking runs the same.)
The important points here are Value Area and UserTableID in the SQL Query area. If you choose all forms for Value Area, it shows all information about this UserTableID on the Client screen. Thus, UserTableID area must be in the query.
The new window for the operation on the Client screen
After the first data is double-clicked, it fills to Client screen.