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