NOTE: You cannot edit any database queries that have been predefined by the API Designer.
You can edit existing database queries at any time.
To edit a database query
-
In the menu bar, click Edit > Edit database queries.
-
Click the database query you would like to edit in the Edit database queries dialog.
-
Enter a unique name for the database query in the Identifier field.
-
(Optional) In the Description field, enter a description for the database query that describes the database query and its function.
-
Enter the query as a SQL code in the SQL expression field.
-
In the Dialog groups section, double-click the dialog groups for which access permissions are to be changed.
TIP: Click Select all or Deselect all to quickly select or deselect all dialog groups.
-
(Optional) Click Test statement to test the SQL statement with different values. For more information, see Testing a database query.
-
Click (Save).
-
Click Close.
Related topics
You can test database queries at any time.
To test a database query
-
In the menu bar, click Edit > Edit database queries.
-
In the Edit database queries dialog, click the database query you would like to test.
-
Click Test statement.
-
In the Test statement dialog, select the check box next to the SQL statement parameters that you would like to include in the test.
-
Enter the values for each parameter in the Value column.
-
Click Test statement.
-
Click Close.
-
Click Close in the Edit database queries dialog.
Related topics
NOTE: You cannot delete any database queries that have been predefined by the API Designer. The Delete button is disabled for such database queries.
You can delete existing database queries at any time.
To delete a query
-
In the menu bar, click Edit > Edit database queries.
-
Click the database query you would like to delete in the Edit database queries dialog.
-
Click (Delete).
-
Confirm the prompt with Yes in the dialog.
-
Click Close in the Edit database queries dialog.
Related topics
Use the Tabs dialog to enable opened tabs, close tabs, or save changes that you have made in tabs.
To manage tabs
-
In the menu bar, click View > Tabs.
-
In the Tabs dialog, click or more tabs (while holding down the Ctrl key).
-
Perform one of the following tasks:
-
Click Enable to enable the tab.
-
Click Save to save tab changes.
-
Click Close tabs to close the tab.
-
Click Close.
Related topics