TCRDBGrid filter problem

[jaydeep_chovatia]

Hi,

I am using TCRDBGrid in my application using TVirtualTable.

- TCRDBGrid has three fields(columns) of type ftString.
- TCRDBGrid has 5 rows containing some textual data.
- TCRDBGrid has filter bar enabled on top

Now i want to filter some text in the rows say for example,

One of my TCRDBGrid cell has some value "123,456,765" . I am interested in finding out all the cells having 456. To do so, i wrote string "*456*" in filter bar, but it gives me following error
"Could not conver variant of type string into type double"

I reffered help file and it says that one can use regular-expression for filtering purpose.

I would appreciate any help on this regards.

Thank you,
Jaydeep

[Plash]

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.

Also supply us the following information
- exact version of ODAC including build number (see Oracle | About ODAC in the IDE menu);
- exact version of Delphi or C++Builder.

[jaydeep_chovatia]

Hi,

Thanks for your quick response.

We are using ODAC version: 5.55.1.24 and
C++Builder version 6.0

Here is the code which populates CRDBGrid in my application
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------
VirtualTable1->Open();
VirtualTable1->Clear();

VirtualTable1->AddField("1", ftString, 100, false);
VirtualTable1->AddField("2", ftString, 100, true);
VirtualTable1->AddField("3", ftString, 100, true);
CRDBGrid1->AdjustColumns();
CRDBGrid1->ShowHint = true;

for(int j = 0; j InsertRecord(vr, 2);

delete []vr;
}

--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------

I wanted to send you a sample application, but i couldn't find any attachement option while posting reply. Could you please also let me know how to attach samples in this forum.

Thank you,
Jaydeep