search query OR

[romi]

Hi,

 

I have a question about search query (OR). I’m not sure if this possible.

Let’s say I have a table T1:

-Id

-FirstName

-LastName

 

Now, I would like to search through this table for anyone with

FirstName=Jhon OR LastName=Smith.

I know I can search first with FirstName=Jhon and after that, second query

with LastName=Smith. No doubt about this but is there any way to do this in

ONE shot, one query ?

 

thank you

[AHunter3]

Not without a calc field to search on instead, no.

 

Why would you not want to do it using a second query? That's how "OR" finds are done in FileMaker.

[Ender]

Use two requests. To add another request, go to Requests->Add New Request.

[romi]

You’re really fast guys. Why 2 requests. Well , it’s not only to find something.

Once it’s done I have to treat the set.

With 2 requests I have to :

1) find with first parameter then treat everything

2) find with second parameter then treat everything

 

more scripting to do

 

thanx

[AHunter3]

?????

 

First Request: FirstName="john"

Second Request: LastName = "Smith"

Perform Find

 

one found set, not two. postprocessing of found set is NOW.

 

Even if what you do to your data is different for the "Johns" than for the "Smiths", you don't have to do it in two processes.

[romi]

That’s exactly what I was looking for …

 

Big thanx