Only by SETFILTER

navuser1 · 2008-10-21

Hi All,

Suppose there is a Table – TestX and its fields are

1. Emp Code (Code)
2. Male (Boolean)
3. Adult (Boolean)

And I want to get data from the table TestX if one of the two fiels Field Male OR Field Adult is true.

Is it possible with the SETFILTER Function Without IF ELSE Function?

Thanks..

kine · 2008-10-21

Add 4. field which will be "Male or Adult" and into OnValidate of Male and Adult add code

"Male or Adult" := Male or Adult;

Than you can filter on this field...

navuser1 · 2008-10-21

Thanx for your reply.

No kine , I cann't add any field.
I just want to know is it possible ..... with SETFILTER without IF ELSE.

Because I have found a SETFILTER Syntax where
SETFILTER contains More that two Table Fields.

kine · 2008-10-21

navuser1 wrote:

Because I have found a SETFILTER Syntax where
SETFILTER contains More that two Table Fields.

??? Where ???

It is not possible to do it in one loop...

sanjeevdalela · 2008-10-21

you user

SETFILTER(Male,'%1',TRUE);
SETFILTER(Adult,'%1',TRUE);

kine · 2008-10-21

Yes, but this will filter Male AND Adult, not or... it means BOTH must be true, request is One of them is true... ;-)

navuser1 · 2008-10-21

kine wrote:

navuser1 wrote:

Because I have found a SETFILTER Syntax where
SETFILTER contains More that two Table Fields.

??? Where ???

It is not possible to do it in one loop...

selected code

SETFILTER("Branch1 Code","Branch2 Code","Branch3 Code",'<>%1|<>%2|<>%3',LocationRequest,'');

"Branch1 Code","Branch2 Code","Branch3 Code", are the table fields
and LocationRequest is the Variable.

kine · 2008-10-21

Did you tried it? No, it is not working in this way... ;-)

navuser1 · 2008-10-21

kine wrote:

Did you tried it? No, it is not working in this way... ;-)

Yes I have tried but it's not working.

Thnx for your valuable comment and support.

PsixoLog · 2008-10-29

Hi all!
To get data from the table if one of the two fields Male OR Adult is true use this:

RESET;
IF FINDFIRST THEN
REPEAT
  IF Adult OR Male THEN
    MARK(TRUE);
UNTIL NEXT = 0;
MARKEDONLY(TRUE);

I think, using only SETFILTER it's impossible.

kine · 2008-10-29

PsixoLog wrote:
Hi all!
To get data from the table if one of the two fields Male OR Adult is true use this:
RESET;
IF FINDFIRST THEN
REPEAT
  IF Adult OR Male THEN
    MARK(TRUE);
UNTIL NEXT = 0;
MARKEDONLY(TRUE);
I think, using only SETFILTER it's impossible.

BUT!!! Do not use this solution if you have thousands and millions of records in the table... [-X

Only by SETFILTER

Comments

Categories