Lets you specify search conditions to limit the list of tables and views that displays in the Installed Database Interfaces Tables list in PocketBuilder. Setting this parameter can be useful if you are working with a very large database in the PocketBuilder development environment.
When to specify TableCriteria
You must specify the TableCriteria DBParm parameter before connecting
to the database in PocketBuilder. The TableCriteria DBParm parameter
has no effect in a PocketBuilder application script.
ODBC
You specify the TableCriteria search conditions on the System tab in the Database Profile Setup dialog box.
None. If you do not specify any values, the TableCriteria parameter is not used.
To specify the TableCriteria search conditions, enter information in the following boxes:
Field |
Description |
|---|---|
Table Name |
Specifies the names of tables to display in the current database. You can use wildcard characters. |
Table Owner |
Displays only those tables belonging to the specified table owner. You can use wildcard characters. If you omit this value, PocketBuilder displays all tables matching the table name that you have permission to access. |
Include Tables |
Specifies that tables should be displayed. |
Include Views |
Specifies that views should be displayed. |
Include System Tables |
Specifies that system tables should be displayed. |
Include Aliases |
Specifies that alias tables should be displayed. |
Include Synonyms |
Specifies that synonym tables should be displayed. |
Type QADB% in
the Table Name box and DWMC31 in
the Table Owner box on the System tab in the Database Profile Setup
dialog box to set the Table Criteria property to:
TableCriteria=’QADB%,DWMC31’
