EnableSQLStatementParams
|
Initial Build |
2017.1 |
|
Module |
Admin |
|
Current Setting Type |
Text Box |
Use this system option to enable or disable SQL Parameterization for the specified query-type families, or areas. For introductory information about SQL Parameterization, see the About SQL Parameterization topic. Enter the sum of the numbers that correspond to the options you'd like to enable. The default for this option is 65536.
You can also enable or disable SQL Parameterization for a targeted metadata query (such as a child form). This process allows you to override the overall area setting in EnableSQLStatementParams but only for your chosen metadata query. Use this process to target a particular query that is causing trouble for the SQL Parameter handling, instead of using the EnableSQLParameters system option to disable parameterization for all queries in this area. See Setting MetaData Flags for SQL Parameterization for details.
Current Setting
The current setting for EnableSQLStatementParams is used as follows:
Values: This system option can be set to enable or disable SQL Parameterization globally or for any single area or a collection of areas.
Global Settings:
| Area Name | Description | Number |
|---|---|---|
| Enable All | Enable SQL Parameterization for every option listed here. | 65536 |
| Disable All | Disable SQL Parameterization for every option listed here. | 0 |
Individual Areas:
To enable SQL Parameterization for an area, enter the number beside that area. If you want to enable SQL Parameterization for more than one area, then add up the numbers for each area and enter the sum. If there is already a sum in this system option and you want to know what areas comprise the number, go to this spreadsheet. Ask for edit access to the spreadsheet, and enter the sum in the Enter Value field.
| Area Name | Description | Number |
|---|---|---|
| CachedMetaData | Only queries controlled by this system option and generated by cached metadata. | 16 |
| ChildFormData | All queries for child-form data. | 4 |
| ChildFormConditional | All SQL database queries that control the behavior of child forms, such as IsVisible, ReadOnly, Row IsVisible, Row ReadOnly, and Add IsVisible. | 8 |
| Formlink | All Form Links Selection and Visibility SQL queries. | 4096 |
| Misc | Only misc queries that are controlled by this system option and have SQL parameters implemented. | 32 |
| MiscConditional | Miscellaneous conditional queries (expressions that control IsVisible, ReadOnly, etc.) that have SQL Parameters implemented. | 8192 |
| Record Select | Parameterize queries generated by DataUtils.SelectByKey(), which is an operation that loads the data for a specific NetForum facade object. | 1 |
| Record Update and Delete | Parameterizes queries used to update and delete NetForum facade objects. | 16384 |
| SelectFacadeDataSet | Parameterize queries generated by DataUtils.SelectByDataRow(), which is an operation that loads the data for a specific NetForum facade object. | 2 |
Default Value: 65536
Fields
This system option includes the following fields:
Description: This field gives the description of the system option, including its use and default value.
Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.
Category: This field sets the category (usually the module) where the system option is used.
Type: The Type field determines the display type of the Current setting field (check box, drop-down list, or text box).
Values: The values field indicates the allowed values for the Current setting field.
Availability
Each system option includes the following availability settings:
Entity Level Option?: Select this check box to make this system option available on an entity level.
Visible To External Systems?: Select this check box to make this system option available in xWeb.