On 3 Dec 2001, at 0:49, pmagor@... wrote:

> 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

I can't get the setrange to work properly, how did u manage it?

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz