Providing query ability to users

When you call the Retrieve method for a DataWindow control, 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 during execution by putting the DataWindow into query mode. To do that, you use the Modify method or a property expression (the examples here use Modify).

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