Do Not Allow Open Queries

Previous Next

Force the use of a search condition by not allowing open queries.

Background

You can enforce the use of at least one query condition in a window by setting the Allow Open Query property to Off (default On).

When to use

Enforce a search condition within windows that are based on large tables. This way you prevent the user from issuing a Query All Records command accidentally.

To enforce the user to enter a search condition in a window:

1.Use the Class Catalog to select and open the appropriate window.
2.Open the Property Inspector, and click the General tab page.
3.Change the Allow Open Query property to No.
4.Save your changes.

Limitations

If you limit query activity using the Allow Open Query property, it will still be possible for the user to use the %-wildcard.