Prompts extend the life of a query and make the query more flexible for future requests.


For example, instead of hard-coding a course ID value in the criteria, you can prompt the user to enter a course ID.


The query becomes more flexible, and you do not have to create multiple queries with hard-coded constant values for each course ID. You run the query, and the query prompts you for the course ID.


You can restrict users' input by using table edits. These types of edits are available for runtime prompts:

• Prompt table.

• Translate table.

• Yes/No table.

Table of Contents