Hiding a row does not fully protect the row from being selected, edited, or even deleted. Although filters let you hide rows in a Browser window, editing operations may still affect the hidden rows. As an example, on the TABLE tab, in the Edit group, clicking Update Column updates every row in a table, even rows that are hidden. Also, after filtering a Browser window, you can still select the hidden rows by executing SQL queries or by performing a mouse selection in a Map window.
To limit an editing operation, so that it affects only the visible rows in a Browser window, on the TABLE tab, in the Selection group, click SQL Select. This command creates a named query that represents the Browser window's visible rows. When you perform other commands on that query table, such as Update Column, those commands affect only the visible rows.