Constraints
You can constrain any updatable query by setting the Query object’s constrained property to true before activating the query. This causes the query to behave more like an SQL-server-based query. New or modified rows that do not match the conditions of the query will disappear from the result set, although the data is saved.