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 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.

SQL