| Initial Build | 2017.1.31 |
| Module | Admin |
| Current Setting Type | Text Box |
Modules > Admin > System Options > Find System Option
Use this system option to specify the regular expression that you want the system to validate for in every SQL Command mentioned in the Execute SQL Tasks. If the SQL Command has characters that are not mentioned in the Current Setting field, then the system will generate an invalid SQL Command error.
The default for this option is: ^(\s|\w|\d|-|_|''|/|@|=)*?$
Current Setting
The current setting for SQLRegexForExecuteSQLTask is used as follows:
Values: This system option can be set any regular expression as required by your association to verify that every SQL Commands in the Execute SQL Schedule Task comply with the regular expression mentioned in the Current Setting field.
Default Value: ^(\s|\w|\d|-|_|''|/|@|=)*?$
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.