AllowUserDefinedQuerySQL 

Initial Build	2006.01 or earlier
Module	Admin
Current Setting Type	Check Box

Modules > Admin > System Options > Find System Option

Use this system option to display or hide a Create SQL button on queries that allows a user to create or modify user-defined query SQL. If this system option is set to true, then an advanced user can manually specify the SQL that is executed when the query runs. The default for this option is true (selected check box).

Current Setting

The current setting for AllowUserDefinedQuerySQL is used as follows:

Values: This system option can be set to true (selected check box) or false (cleared check box).

• true—All query forms in iWeb have a Create SQL button that allows users to manually specify the SQL that is executed when a query runs.
• false— Query forms in iWeb do not have a Create SQL button.

Default Value: true

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.