Page 1 of 1

Using Filter Bar of TCRDBGrid Component

Posted: Mon 09 Oct 2006 19:45
by jtuksal
Using: Delphi 5, ODAC version 5.80.0.36 (or earlier)

The help file for the CRDBGrid states in the "Using Filter Bar of TCRDBGrid Component" topic:

"For fields which accept string values you may specify filter mask in the statement substituting masked characters with an asterisk or percent ('*' or '%') symbol . To substitute a single character use underscore ('_') mask symbol."

I have a column that contains the value "JLT" in some rows. When I drop down the filter bar and enter a filter of "J*" those row are displayed. When I enter a filter of "J%" zero rows are displayed.

What's up?

Jim Tuksal

Posted: Thu 12 Oct 2006 09:45
by Plash
When you enter a text into the filter bar of TCRDBGrid component it sets Filter property of linked dataset. Therefore supported wildcards depend on type of dataset you use. ODAC dataset components, such as TOraQuery and TOraTable, currently do not support '%' character as a wildcard.