Скачать: CL | DM;

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 ;-\

---

Страницы: 1 вся ветка

Скачать: CL | DM;



Память: 0.46 MB
Время: 0.009 c