CRDBGrid Filter on Boolean

[dhammink]

Hi,

I have a Table with a TinyInt(1)
is set Bby MyTable as a TBoolean field
I have set DisplayValue=J;N

Now I want to use the CRDBGrid's filter and set the filter to J. Then I get an error Field J not found (For N the same)

I just reverted to Smallint Values.

Anyway I can use the filter in this case as normal Characters ??

[Antaeus]

Thank you for information. We have added analysis of DispalyValues property of TBooleanFileds to CRGrid filtering. This functionality will be added into the next build of our products. If you want us to send this patch to you by e-mail, you should send us your registration information to evgeniyD*crlab*com.

[dhammink]

While you are at it it would realy be nice if TLookupFields are treated in the grids with Lookupcomboxes in the Filter.

I have made something alike with an extra panel on top. but nicely integrated would really be a help.

[Antaeus]

In the next version of our products we will add ability to perform searching and filtering by lookup and calculated fileds. This feature will be included into all our products: ODAC, MyDAC, SDAC, IBDAC.