Filter problem

kenl · 2005-09-05

Hello,

I have a case like this:

I have a field to store location code filter. (The value may be 'w1..w5' , 'w1|w5..w10' or any valid field filter)

Now given a location code (eg. w2), I would like to know, whether the location is match within the location code filter.

How can I do it? Any suggestion?

Thanks.

Marije_Brummel · 2005-09-05

Hi,

First thing I Think of:

Create Temporary Location Table

Location.Setrange(Code, LocationFilter);
If Find('-') then repeat
  CopyToTempTable
Until next = 0;

if templocation.get(w2) then
  IsInFilter;

Maybe to complex? I think it should work

kine · 2005-09-05

take Location table as temporary table, clear it, insert your value, apply filter, if result is empty, it is not within, if you get one record, it is within...

Marije_Brummel · 2005-09-05

Also Possible (2nd Tought)

locationisinfilter := FALSE;

Location.Setrange(Code, LocationFilter); 
If Find('-') then repeat 
  if location.code = 'W2' then
   locationisinfilter := TRUE;
Until (next = 0) or locationisinfilter;

Know you have 3 options

kine · 2005-09-05

3rd option:

Location.SetFilter(Code, LocationFilter);
Location.FILTERGROUP(1);
Location.Setrange(Code,'W2');
Location.FILTERGROUP(0);

if Location.ISEMPTY then
  //Is not within
else
  //Is within

It will do this filtering: LocationFilter AND 'W2'

Waldo · 2005-09-05

Didn't try this out, but may be something like this (4th option):

Location.SetFilter(Code, LocationFilter); 

Location.Code := 'W2';
if NOT Location.FIND('=') then 
  //Is not within 
else 
  //Is within

kenl · 2005-09-06

Hello all,

Thanks for all of your suggestion.

Filter problem

Comments

Categories