Prompt for Criteria

When a retrieve is performed, a dialog box appears and prompts the user to supply Retrieval Criteria.

This is set for each column you wish to prompt for criteria.

Dw_1.Object.Emp_lname.Criteria.Dialog = ‘yes'
Dw_1.Object.city.Criteria.Dialog = ‘yes’

Query mode should be off as this could cause conflicting WHERE clause criteria.

If you wan users to specify sort criteria as part of the select, use QuerySort mode

If you want to limit the columns a user can specify criteria, use Prompt for Criteria

Prompt for criteria forces you to use any edit style set in the datawindow painter, query mode allows you to override this.