Counting Data Rows

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Browsing Data Sources >

Counting Data Rows

You can display the number of rows contained in a table or view directly in the Online Browser without having to retrieve the data first. The context menu provides an additional Row Count sub-menu for this purpose, which contains options for showing/updating and clearing the row count. The Row Count sub-menu is also available for the Tables and Views folders and their sub-folders, allowing you to update the row count information for all tables or views with a single click.

ob_update-row-count

When you move the mouse cursor over tables or views in the Online Browser, a hyperlink appears to the right of the object name. This hyperlink reads "(count)" if no row count has been done yet (see screenshot above), or "(n) update" if a number of n rows has already been retrieved. Clicking this hyperlink will also update the row count information.

 

To disable the row count feature, clear the Optional display of Table and View row counts check box in the Online Browser options.

 

To show the row count in the Online Browser:

1.Make sure that the Optional display of Table and View row counts check box is selected in the Online Browser options.
2.Do one of the following:

 

Right-click a table, view, or folder containing tables or views in the Online Browser and select Row Count | Show/Update from the context menu.
Place the mouse cursor over a table or view and click the (count) hyperlink that appears.

 

3.To update the row count information, repeat step 2. Note that the hyperlink reads (n) update, where n is the number of rows.

 

To hide the row count:

Right-click a table, view, or folder containing tables or views in the Online Browser and select Row Count | Clear from the context menu.

© 2019 Altova GmbH