Filter
Top Products
Manipulating data
90 DataWindow .NET
❖ To remove the filter:
1 Select Rows>Filter from the menu bar.
The Specify Filter dialog box displays, showing the current filter.
2 Delete the filter expression, then click OK.
Filtered rows and updates
Filtered rows are updated when you update the database.
Viewing row information
You can display information about the data you have retrieved.
❖ To display row information:
• Select Rows>Described from the menu bar.
The Describe Rows dialog box displays showing the number of:
• Rows that have been deleted in the painter but not yet deleted from the
database
• Rows displayed in Preview
• Rows that have been filtered
• Rows that have been modified in the painter but not yet modified in
the database
All row counts are zero until you retrieve the data from the database or add a
new row. The count changes when you modify the displayed data or test filter
criteria.
Importing data
You can import data from an external source and then save the imported data
in the database.
❖ To import data:
1 Select Rows>Import from the menu bar.
The Select Import File dialog box displays.