vladk1973
Advanced Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
Hi all
Кто -нибудь юзал фильтры ?
Stfilter.Visible := True;
Stfilter.Local := True;
Цитата: Adjusting grid for filtering data:
TDBGridEh allows to show special row (under title) where user enter expressions in cells for filtering records in dataset. (Expression in the cell can look like: "1", ">=1", ">1 AND <=5", "%TestStr%"). Set STFilter.Visible to True to show this special row. AT Run time, when cursor reside in the filter cell they can press ENTER to apply filter. Grid will parse expression in every not empty filter cell and call TDBGridEh.ApplyFilter, call OnApplyFilter event or pass action to special object, if it registered.
For normally parsinging, the expression in cell have to has next format:
[Operator1] Operand1 [)] [AND|OR Operator2 Operand2 [)] ]
Where OperatorX is one of [ = | <> | != | > | < | >= | <= | ~ | !~ | in ( ]
OperandX is a numeric, date or string value or for the operator 'IN' it is a list of values divided by comma.
For instance:
'1'
'>=1'
'>1 AND <=5'
'~ TestStr%'
'!~ TestStr_'
'in (1,2,3,4,5,6) and >100'
'in (Str1,Str2,Str3)' |
У меня грид отображает TClientDataSet
так вот при задании фильтра на текстовом столбце, например '%АБВ%' и нажатии enter вылетает ошибка "Type mismatch in expression." Копал ли кто такую проблему ?
Ehlib 4.1
Delphi 6
|
Всего записей: 674 | Зарегистр. 23-03-2005 | Отправлено: 03:42 27-09-2006 | Исправлено: vladk1973, 04:07 13-10-2006 |
|
