Главная страница | назад





Article #15237: Filter for TDataSet in C++Builder

 Question and Answer Database

FAQ237C.txt   Filter for TDataSet in C++Builder
Category   :Data Components
Platform    :All
Product    :C++Builder  1.x

Question:

How do I set a filter on a field in a TDataSet,
when the field has a special non-alpha character in the
name( such as "/", as in the State/Prov field in the
DivCust.db table found in the examples).

Answer:

The field name must be surrounded with "[]" (square brackets).

For Example:

Table1->Filtered = true;
Table1->Filter = "[State/Prov] = 'CA'";
Table1->Refresh();

7/2/98 10:32:32 AM
 

Last Modified: 01-SEP-99