find x0r

[stubanz]

Is there any way to perform a find in script mode where the finder omits results with * in one field OR in another field? Any help is greatly appreciated, thanks.

[Lee Smith]

Hi stubanz, and welcome to the forum.

To do an OR find, you need two find requests.

Enter Find Mode

go to field A, and enter *

new record request

go to field b, and enter *

perform find by hitting the Find button.

HTH

Lee

[stubanz]

Thank you very much!

[-Queue-]

Both requests would need the Omit box checked, of course.

[Søren Dyhr]

To do an OR find, you need two find requests.

Right answer, but wrong question ...or the other way 'round. The header says XOR which means the truthtable produced by this bolean calc:

(not A and : or (A and not :

Which makes -Queue-'s answer kind of reaching in the right direction, but unfortunately the way it's implemented in filemakers requests, does it give the wrong set of records. XOR means the records where only one of the fields are empty; not both!

I havn't solved the problem elegantly yet ...but there must be thrown a Contstrain ..or Extend -found set into the applied logic! MEANWHILE would I make a calc'field containing Count(FieldA,FieldB) and instead search for "1" in it....

--sd

[Lee Smith]

What?

stubanz said

results with * in one field OR in another field?

[color:"blue"] I responded with description of an OR find. (although I omitted the Omit)

Sometimes I think you read too much into things.

I try to answer the questions, not the Subjects..

lee

BTW [color:"red"] stubanz stated that that was what he/she was after.

[comment]

If I had to guess I would say it's wrong header..

Anyway, it doesn't seem too hard to do - or am I missing something?

xorFind.fp7.zip

[Søren Dyhr]

or am I missing something

Probably not but isn't it

not(a xor :

...your template shows, not that it matters much! It's the way to approach the matter indeed.

Lee you said I laid too much in the header, but isn't precedence here that everyone approaching these forums are grokkers until the oppsite is established?? This means that everything is should be regarded as a challenge with a certain golfing handicap, so when a copy/paste or a question regarding repeaters pops up ... is it because the "champion" wish to get imput on deliberate denormalizing behaviours of their otherwise normalized tables at hand??

--sd

[Lee Smith]

Lee you said I laid too much in the header, but isn't precedence here that everyone approaching these forums are grokkers until the oppsite is established?? This means that everything is should be regarded as a challenge with a certain golfing handicap, so when a copy/paste or a question regarding repeaters pops up ... is it because the "champion" wish to get imput on deliberate denormalizing behaviours of their otherwise normalized tables at hand??

I was going to ask what this meant, but decided I really don't care.