RpReport:SQLFilterWhere Access/Assign

<< Click to Display Table of Contents >>

Navigation:  RpReport Class >

RpReport:SQLFilterWhere Access/Assign

Previous pageReturn to chapter overviewNext page
Type        String


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.


// 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.