Providing query ability to users

When you call the Retrieve method for a DataWindowControl, the rows specified in the DataWindow object's SELECT statement are retrieved. You can give users the ability to further specify which rows are retrieved at runtime by putting the DataWindow into query mode. To do that, you use the Modify method with a property expression.

NoteLimitations You cannot use query mode in a DataStore or WebDataWindowControl, or in a DataWindow object that contains the UNION keyword or nested SELECT statements.