SQL Settings

Click to enlarge the figure

Figure 5: SQL settings

Elements for SQL settings are used on the custom templates in which SQL clauses are used. These are used in some default templates and templates made by consultants.

Element

Attributes

Possible values

<data>

 

 

      <sqls>

 

 

            <sql>

 

 

id

 

                 <sqlstatement>

 

 

               <type>

 

execute, retrieve

                 <mode>

 

row, area

Elements, attributes, and possible values

Click to open/close expanding section<data>

Path: <document><settings><data>

Contains the SQL scripts that are run when the template is opened or saved.
Click to open/close expanding section<sqls>

Path: <document><settings><data><sqls>

In the SQL clauses that are run during saving for every row, it is possible to refer to the value of a specific column. The column identifier is the 'id' value of the <customdatacolumn> element, and it is separated from the rest of the SQL clause using colons (:column id:).
Click to open/close expanding section<sql>

Path: <document><settings><data><sqls><sql>

Contains one SQL script and its settings.

Attributes

id: ID of the SQL script
Click to open/close expanding section<sqlstatement>

Path: <document><settings><data><sqls><sql><sqlstatement>

Defines an SQL script, for example, for saving or retrieving data. The order in which the SQL clauses are run can be defined with the <sqlorder> element.
Click to open/close expanding section<type>

Path: <document><settings><data><sqls><sql><type>

Defines the type of the operation of the SQL script.

Possible values:

•execute: The script saves data from the template.

•retrieve: The script retrieves data to the template.
Click to open/close expanding section<mode>

Path: <document><settings><data><sqls><sql><mode>

Defines how the SQL script is run.

Possible values:

•row: The script is run row by row for the template.

•area: The script is run for a whole area of the template at a time.