Filtering Paradox in Delphi

← →
IKA (2003-08-04 15:04) [0]

hello!
Thank you for help in advance.
The problem is that I can"t filter as I want :(
Example:
I have 3 field with this reccords

autoinc integer integer
^ ^

"ID" "PERSON" "score"
1 1 2
2 1 1
3 1 3
4 1 1
5 1 4

6 2 1
7 2 3
8 2 2
9 2 2 ( nothing) hello!
Thank you for help in advance.
The problem is that I can"t filter as I want :(
Example:
I have 3 field with this reccords

autoinc integer integer
^ ^

"ID" "PERSON" "score"
1 1 2
2 1 1
3 1 3
4 1 1
5 1 4

6 2 1
7 2 3
8 2 2
9 2 2

When give filter "person=1" and "score=2" and "score=1"
and make it true it gives me this reccords (nothing):

autoinc integer integer
^ ^

"ID" "PERSON" "score"

but when I give filter "person=1" and "score=2" or "score=1"
it gives me this reccords:

autoinc integer integer
^ ^

"ID" "PERSON" "score"
1 1 2
2 1 1
4 1 1

6 2 1
8 2 2
9 2 2

I want to get reccords where person is ONLY 1 and the score is 2 and 1,
I Dont want Person 2 and others.

autoinc integer integer
^ ^

"ID" "PERSON" "score"
1 1 2
2 1 1
4 1 1

← →
Mike1 Kouzmine1 (2003-08-04 15:12) [1]

Возьми в скобки.

← →
KDS (2003-08-04 16:10) [2]

filter:="person=1 and (score=2 or score=1)"

← →
Anatoly Podgoretsky (2003-08-04 16:14) [3]

record have no two values at same time

← →
IKA (2003-08-05 13:07) [4]

thank you, well done
:)

← →
SPIRIT (2003-08-05 15:59) [5]

nevermind ;-\

Filtering Paradox in Delphi Найти похожие ветки