<< Click to Display Table of Contents >>
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.
// Set SQL filter to show customers in California
oQuery:SQLWhere := "customer.state = 'CA'"