The next table presents the properties of SQL queries.

Property

Description

Optionality

Default value

Obs.

Name

Name of the Parameter.

Mandatory

Inn

See rules for naming elements.

Description

Free text that describes the query parameter. You can edit the text by directly typing it in the property or in the description editor which opens by clicking

Optional

 

Useful for documentation purposes.

The maximum size of this property is 2000 characters.

Data Type

List of all the supported data types, except Object, Record, and Record List. In this list you'll also find the Identifiers of all the entities.

Mandatory

Text

 

Expand inline

Describes whether the parameter should be textually expanded into the SQL or used as a common parameter.

Mandatory

No

When using expand inline parameters, you should use the EncodeSql function to prevent SQL injection in the database.

See Also

SQL Parameters