|
<< Click to Display Table of Contents >> RpReport:SQLFilterWhere Access/Assign |
  
|
RpReport:SQLFilterWhere Access/Assign
|
<< Click to Display Table of Contents >> RpReport:SQLFilterWhere Access/Assign |
|
| Type | String |
Purpose
To get/set the optional filtering condition in a rpSQLQuery's SQL SELECT statement. Internally, the rpSQLQuery object stores the select statement in distinct chunks. This allows sections of the SELECT statement to be manipulated without disrupting other sections which are automatically maintained by the rpSQLQuery object. The assigned value must be a valid expression to the ODBC driver and/or SQL server.
Example
// Set SQL filter to show customers in California
oRpReport:SQLFilterWhere := "customer.state = 'CA'"
| Note: | This access/assign maps directly to the first table object in the primary section. It only applies if the first table object is a rpSQLQuery. |