Avery Dennison Label Printer

To Next Page

To Previous Page

Avery

Personal Label Printer

106

Filters can be very useful when printing or when moving between records, since only records

that match the filter criteria are available. The following criteria can be enabled to filter

records:

• Field - Select fields for which you want to define filter conditions.

• Compare - Select an operator from the list and determine the way in which you would like

to perform the query.

• Compare With - Type the condition or value with which the field content is to be compared.

You can use wildcards if the field contains data of the data type Text. This option does not

exist for comparisons with other data types. The wildcards are different for ODBC and

dBASE databases but correspond to the usual characters in each case. For further infor-

mation, refer to the DesignPro Help file.

• And/Or - Select And or Or to link the conditions between different fields.

• Only Tagged Records - Select all records which match the filter conditions AND are tagged

(available only for dBASE databases containing a tag field).

• OK - Closes the dialog box and starts the query.

• Cancel - Closes the dialog box without filtering.

• Delete All - Deletes all filter settings.

Displaying Database Information

Select Database > Database Info to display the Database Information dialog box. For a

dBASE database, the following information is displayed.

• File - Path and name of the currently open database file.

• Status - Database is linked or not linked.

• Total Number of Records - Total number of records in the dBASE database including all

deleted records before compression of the database.

• Number of Active Records - Number of available records (matching the filter conditions).

• Compress Database - Removes deleted records from the dBASE database.

For an ODBC database the following information is displayed:

• Data Source - Name of the database.

If no record matches the filter conditions then no records will be displayed in the Edit

Database dialog box and the fields of the record will appear empty.

Avery Dennison Label Printer - Page 120