| Форумы
ЧАТ |
Орешник |
|
| Форумы -» | Основная («Начинающим»)/ Базы / WinAPI / Компоненты / Сети / Media / Игры / Corba и COM / KOL / FreePascal / .Net / Прочее / RSDN.ORG |
|
| ||
|
|
Новости |
Поиск |
FAQ |
Статьи |
Книги |
Новости VCL
| | Форумы ЧАТ |
Орешник |
|
| |||
| |||
| |||
« предыдущая ветвь | форум | следующая ветвь »
Filtering Paradox in Delphi
IKA © (2003-08-04 15:04:00)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
SPIRIT (2003-08-05 15:59:00) [1]
nevermind ;-\
IKA (2003-08-05 13:07:00) [2]
thank you, well done
:)
Anatoly Podgoretsky (2003-08-04 16:14:00) [3]
record have no two values at same time
KDS (2003-08-04 16:10:00) [4]
filter:="person=1 and (score=2 or score=1)"
Mike1 Kouzmine1 (2003-08-04 15:12:00) [5]
Возьми в скобки.
| |
