How To…Create Invisible Search Criteria

Question

“How can I add search criteria that will be not be visible to my end-users?”

Solution

The following example shows how to use the DataView.OnBeforeGenerateSQL and OnAfterGenerateSQL events to and remove search criteria that cannot be seen by the end-user.

Download:  DADEInvisibleSearchCriteria.zip

Delphi code sample: