Also I have found that using the filter and filtered property will
over write the range that was set in setrange.

eg where clause after setrange before filter

WHERE CUSTOMER_CODE >= ? /* RBEG_CUSTOMER_CODE */
AND CUSTOMER_CODE <= ? /* REND_CUSTOMER_CODE */

where clause after setrange and filter (filter applied last)

WHERE (IS_ACTIVE = 'T')

if you apply the filter before the setrange then it produces the
correct where clause

Peter Magor