Page 1 of 1

CRDBGrid Filter on Boolean

Posted: Wed 28 Jun 2006 21:40
by 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 ??

Posted: Thu 29 Jun 2006 12:02
by 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.

DataGrid

Posted: Thu 29 Jun 2006 12:12
by 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.

Posted: Fri 30 Jun 2006 09:44
by 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.