<< Click to Display Table of Contents >> Navigation:  RpSQLQuery Class > RpSQLQuery:SQLWhere Access/Assign

Purpose

To get/set the optional filtering condition in the 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 expression must be a valid expression to the ODBC driver and/or SQL server.

Example

// Set SQL filter to show customers in California

oQuery:SQLWhere := "customer.state = 'CA'"