Фильтраия по 2 и более полям

← →
IntruderLab © (2006-06-26 14:22) [0]

Ситуация такая, мне необходимо сделать фильрацию для TADOTable по двум значениям, значения выбираются из LooucpComboBox (что не так важно), но тем не менее хочеться, чтобы фильтрация была по двум значениям:

пример

adotTable.Filtered := False;
adotTable.Filter := cbOne.KeyField + ";" + cbTwo.KeyFieldl
adotTable.Filtered := True;

данный пример не работает, как добиться подобного?

← →
IntruderLab © (2006-06-26 14:27) [1]

Сразу скажу, что можно применить TADOQwery, но просто не хочу :) если нет вариантов, конечно использую SQL запрос в ADOQwery

← →
Vlad © (2006-06-26 14:36) [2]

Справку уже читали?

← →
IntruderLab © (2006-06-26 15:15) [3]

к несчатьюЮ справки стандартной делфи у меня на компе сейчас нет..

← →
Sergey13 © (2006-06-26 15:17) [4]

> [3] IntruderLab © (26.06.06 15:15)
> к несчатьюЮ справки стандартной делфи у меня на компе сейчас
> нет..

Будет - посмотри. Интересно.

← →
Vlad © (2006-06-26 15:26) [5]

Высылаю.
---------------------------------------------------------

Filter property (TCustomADODataSet)

Specifies the text of the current filter for a recordset.

Delphi syntax:

property Filter: String;

C++ syntax:

__property AnsiString Filter = {read=FFilterText, write=SetFilterText};

Description

Use Filter to specify a recordset filter. When filtering is applied to a recordset by setting the Filtered property to true, only those records that meet a filter’s conditions are available to the application. Filter contains the expression used to evaluate the rows in the recordset. At design-time, enter the filter expression into the editing cell for the Filter property within the Object Inspector. At runtime, assign a string containing the filter expression to the Filter property.

The filter expression below displays only those rows where the State field is "CA" or "MA":

State = "CA" OR State = "MA"

The following runtime example shows how to assign that filter expression to the Filter property and activate the filtering.

with ADODataSet1 do begin
Filtered := False;
Filter := "State = " + QuotedStr("CA") + " OR " +
"State = " + QuotedStr("CA");
Filtered := True;
end;
ADODataSet1->Filtered = false;
ADODataSet1->Filter = "State = " + QuotedStr("CA") + " OR " + "State = " + QuotedStr("CA");
ADODataSet1->Filtered = true;

When a filter is set, Blank records do not appear unless explicitly included in the filter. To include rows based on blank, (or "NULL") values in table columns, compare the column to NULL in the expression. For example:

with ADODataSet1 do begin
Filtered := False;
Filter := "State = " + QuotedStr("CA") + " OR " +
"State = NULL";
Filtered := True;
end;
ADODataSet1->Filtered = false;
ADODataSet1->Filter = "State = " + QuotedStr("CA") + " OR " + "State = NULL";
ADODataSet1->Filtered = true;

Tip: Applications can set Filter at runtime to change the filtering condition for a dataset at (for example, in response to user input).
Note: include a space between comparison values and comparison operators in filter expressions. For instance, ensure that there is a space after the field name and before the operator.

Когда догадаешься, обязательно в фильтре используй скобки, а то фильтр не заработает.

Типа:

Filter = "Field1 = ("+QuotedStr(Edit1.Text)+" AND ("+QuotedStr(Edit2.Text)+"))";

Фильтраия по 2 и более полям Найти похожие ветки