Lets you specify search conditions to limit the list of tables and views that displays in the Installed Database Interfaces Tables list in DataWindow Designer. Setting this parameter can be useful if you are working with a very large database in DataWindow Designer.
When to specify TableCriteria You must specify the TableCriteria parameter before connecting to the database.
The TableCriteria parameter has no effect in a DataWindow .NET application.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
ODBC
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
You specify the TableCriteria search conditions on the System page in the Database Profile Setup dialog box.
None. If you do not specify any values, the TableCriteria parameter is not used.
Oracle If you do not specify a value for TableCriteria, all Oracle tables, views, and synonyms that you have permission to access display in the Installed Database Interfaces Tables list by default.
To specify the TableCriteria search conditions, enter information in the following boxes:
Type QADB%
in
the Table Name box and DWMC31
in
the Table Owner box on the System page in the Database Profile Setup
dialog box to set the Table Criteria property to:
TableCriteria='QADB%,DWMC31'