Previous TopicNext Topic


How to insert a parameter marker in the SQL query

This procedure assumes that you already created a data set.

  1. In 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, as shown in the following examples:
  3. WHERE quantityinstock < ? 
    WHERE quantityinstock <= ? AND productvendor = ? 
    WHERE quantityinstock <= ? OR productline LIKE ? 
    
    Figure 12-11 shows an example of a query with two parameter markers.

    Figure 12-2 Query with two parameter marker

    Figure 12-11 Query with two parameter markers

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