Set Selection Group question

[Andrew2009]

Here's my simple requirement

select all people where age = 18 and name is either John or Jane

Set Selection Group(FC Grid,F1234,"AGE",<Equal To>,"18",<And>)

How do you do either or for Name?

Thanks

 

[Zoltan_Gyimesi]

Hi Andrew,

[ QUOTE ]
select all people where age = 18 and name is either John or Jane


[/ QUOTE ]
I do not know F1234 table at least in XE, so hard to help you.

What is yor scope? World, Asia, Europa, America, Atlantis, Moon, Mars, etc. ...maybe just "Hungary"?

Please, include your selection "Except 'zoltán'" - I am not John and not Jane and a bit older, than....

Zoltán over 18+

 

[Rayxue]

Try this
Set Selection Group(FC Grid,F1234,"AGE",<Equal To>,"18",<And>)
Set Selection Group(FC Grid,F1234,"NAME",<Equal To>,"John",<And>)
Set Selection Group(FC Grid,F1234,"NAME",<Equal To>,"Jane",<or>)

OR to be safty,turn debug log, run the UBE, log will show SQL statement which you can double check.

Ray

 

[Chan Rana]

Refer to SQL document on how to design such statement.

Chan

 

[DBohner-(db)]

Set Selection Group(FC Grid,F1234,"AGE",<Equal To>,"18",<And>)
Set Selection Group(FC Grid,F1234,"NAME",<Equal To>,"John",<And>)
Set Selection Group(FC Grid,F1234,"AGE",<Equal To>,"18",<Or>)
Set Selection Group(FC Grid,F1234,"NAME",<Equal To>,"Jane",<AND>)

??

(db)

 

[Andrew2009]

DBohner...your suggestion works.

Thanks everyone else for your suggestions.

 

[Rayxue]

Daniel,

I think SQL will be Select Age = 18 and (Name = "John" or name = "Jane")

Please advise