Remove Automatic Query

Previous Next

Prevent automatic full table queries for lookup windows.

Background

When opening a lookup window, an automatic query is performed. Especially for large tables, this can be a drain on performance. The easiest way to get rid of automatic queries is to remove the Startup Actions setting of Lookup Windows. This setting defaults to PerformQuery().

When to use

You can use this tip on three different levels:

•For the generic Lookup Window class, if you do not want automatic queries in lookup windows at all.

•For a specific Lookup superclass, if you do not want automatic queries in lookup windows for one table.

•For a specific lookup window, if you only do not want automatic queries for a specific lookup window.

To prevent automatic full table queries in lookup windows:

1.In the Windows Designer, open the appropriate lookup window class.
2.Open the Property Inspector for the selected class.
3.On the Behavior tab page, select the Startup Actions property.
4.Remove the PerformQuery() call.
5.Save.