Editing prompting queries

After creating a prompting query, you can edit it just like any query.

Procedure

  1. Open an existing prompting query.
  2. Click Edit. You see the Edit Prompting Query dialog box.
  3. In the query string, edit the existing placeholders as required, or add new ones.

    You can have multiple prompts in a prompting query.

  4. Click Next to open the Edit Prompting Query - Customize Placeholders dialog box.
  5. In the Type or Attribute column, edit the value used in the query.

    Edit or add a type, as required. Your query prompt shows the entries you defined for that type.

    • For a String or Date value, edit or type the Label to be displayed, and then click Next.

      Skip to step 7 if you have no other placeholders to edit.

    • For a list box value, complete the substeps.
      1. Click Edit Values. You see Edit Values for Placeholder%n dialog box.
      2. Update the entries in the list box, as required. Repeat until your list is complete. You can order or delete entries by using Up, Down, and Delete.
      3. Click OK.
      4. Type a label for the field.
      5. Edit or add other types, as required.
      6. Edit or add an attribute, as required. Your query prompt shows the current values for that attribute.
      7. Select the attribute, change the label as required, and then click Next.
      8. Edit or add other attributes, as required.
  6. Click Next when you have finished updating the placeholders.
  7. In the Save dialog box, update the description of the prompting query you modified.
  8. Click OK.
  9. To check your query, select it from the appropriate folder. Set the value from the list you created, then select a format and click Run. Click Edit to modify the query.

Feedback