Previous TopicNext Topic


How to insert a parameter marker in the SQL query

This procedure assumes that you have already created a data set.

  1. In the data explorer, right-click the data set whose query you want to edit, then choose Edit. Edit Data Set displays the query.
  2. Add a WHERE clause with one or more parameters.
  3. WHERE quantityinstock < ? 
    WHERE quantityinstock < ? AND productvendor = ? 
    WHERE quantityinstock < ? OR productname LIKE ? 
    
    Figure 12-2 shows an example of a query with a single parameter marker.

    Figure 12-2 Query with one parameter marker

At this point, you are ready to create a data-set parameter for each ? parameter marker. The next section describes this task.


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic