Go to Scriptcase store

# Procedure SQL Settings

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

#### Foreign key fields

Displays the fields identified as foreign keys in the database structure.

These fields will be used by Scriptcase for automatic mapping when creating links between applications. When the application is used as the destination of a link, this mapping can avoid the need to create global variables in the application SQL.

#### Grid sorting fields

Defines the fields used in the initial sorting of the Grid.

The fields selected in this option will be considered by Scriptcase to build the application’s default sorting.

> To define custom sorting directly in the Grid SQL, clear the fields selected in this option.

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