Previous TopicNext Topic


How to insert a parameter marker in the SQL query

This procedure assumes you already created a data set.

  1. In Data Explorer, right-click the data set whose query you want to edit, then choose Edit.
  2. Edit Data Set displays the query.
  3. Add a WHERE clause with one or more parameters.
  4. WHERE salesTotal >= ? 
    WHERE state = ? AND customerName = ? 
    WHERE state LIKE ? OR salesTotal >= ? 
    
    The following illustration shows an example of a query with a single parameter.

  5. Now, 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