ABC: Range limiting and filtering 1999-01-08 -- Dennis E. Evans Newsgroups: topspeed.products.c5ee
>What the best way to turn a range limit off in a browse when you don't want
>in on, using a variable while the browse is open.
The best that I have found is to not use the range limit.
The only external difference, I am sure the view engine does
a lot of things different internally, is that criteria added as a
range limit are placed in the view prop:filter
before any standard filter conditions.
See the View Manager, ApplyRange and
ApplyFilter methods.
To add a filter, that works as a range limit use the
View Manager SetFilter method and include the priority
parameter. You still need to use criteria based on fields from keys.
pseudo code set range limits
get range limit values
SetFilter('FldName >= RangeStart and
FldName <= RangeStop', '9') ! high priority get other filters
Set Filter('Filter conditions', '8') ! lower priority reset
pseudo code range limits off
SetFilter('', '9') ! same priority as before reset
This will take a while to get use to, but once you get accustom to it, range
limits are much more flexible.
The only time I use range limits now is when I want to limit
by file relationship, single value or range of values
I use the SetFilter Method.
Hope it helps.
Dennis
Printed May 5, 2024, 1:00 am This article has been viewed/printed 35118 times. Google search has resulted in 17 hits on this article since January 25, 2004. |