Load Query Result

A type of operation that allows a prepared report or information query to be passed to the Grid form control attached to the form.

Show Content Query 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: SQL query will be written here.

Line Looking: The selection of whether or not to be navigated individually in the lines of the list to be transferred is made.

Clear Content: In order not to add the information in the list one by one, it is made to choose whether to clear the grid content or not.

Map by Columns: The choice of whether to match the column names of the girth in the query is made. Otherwise, it will transfer in the column order.

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

There are a button and grid form controls. The button has a Show Content query operation with When clicked event.

The grid has three columns according to the query.

Client view on screen

When the button is clicked, the data in the query fill to the Grid form control.

Client view on screen