SQL

SQL Settings

This interface allows configuring the related database settings, such as the SQL statement, the used database connection, case sensitive, and others.

Grid SQL configuration

SQL Select Statement

It allows you to define the primary SQL of the application. You can edit this SQL to add or delete fields.

Limit

Lets you limit the display in the number of records retrieved by SQL query.

SQL Preparation

You can enter SQL commands or procedure names to execute them before the primary SQL of the application.

Connection

It allows defining the database connection of the application. You can change the connection to another one that has the same table.

Use Customized Message

Lets you define to display the “no records” message or not.

No Records Message

Lets you set the message when the application has no records.

Font

This option is available when using the “Use Customized Message” option. It lets you set the font for the message.

Font Size

This option is available when using the “Use Customized Message” option. It lets you to set the font size.

Font Color

This option is available when using the “Use Customized Message” option. It lets you to set the font color.

Variable for Table

It allows to use a variable to change a part of the string containing the table name.

Fill the first input with the name of the variable (replace to). The second input you should fill with the part of the name of the table you want to replace (replace from).

Fields Variables

It allows to use a variable to change a part of the string containing the field name.

Fill the first input with the name of the variable (replace to). The second input you should fill with the part of the name of the field you want to replace (replace from).

Case sensitive

It defines if the database connection uses case sensitive or not.

Creating Parameters for Applications Links

Parameters are used to pass values between applications. When the target application is a query, we recommend adding a global variable in the WHERE clause to filter the records that meet a specific condition.

To configure the parameter, in the destination application, access the SQL option in the left side menu.

We must edit the SQL of the grid application, adding the WHERE clause and the field that receive the value through a global variable(as shown in the image below).

after edition, we must generate the source code of the application clicking on the button - - or using the hotkey F8.