Using Filter Bar of TCRDBGrid Component

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jtuksal
Posts: 1
Joined: Thu 10 Mar 2005 13:57
Location: Southfield, MI

Using Filter Bar of TCRDBGrid Component

Post by jtuksal » Mon 09 Oct 2006 19:45

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
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 12 Oct 2006 09:45

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.
Top
Post Reply

Return to “Oracle Data Access Components”