Page 1 of 1

Query by example mode?

Posted: Sat 08 Nov 2008 22:29
by uko
Hi,

I know from oracle forms and another Oracle access package, that they have an 'query by example' mode, where after entering this mode you fill out the fields with partial data and when executing the mode, the dataset is filtered by those data. As I found this a very fast way to query for needed data I'd like to have this also on Firebird DB.
Is there something similar for IBDAC or can someone give hints how to simulate such a feature with IBDAC (something that comes to mind for me is: make all database fields be editable, enter a new record, fill the fields and instead of posting the data, bild a filter criteria and then cancel the new record and apply the filter)

Maybe I'm also on the wrong way, so lets ask the other way: how do you make querying for certain data available to your endusers (should be a fast and intuitive way :) )

best regards,
Ulrich

Posted: Mon 10 Nov 2008 08:36
by Plash
You can use the TCRDBGrid component that is installed on the Data Controls page. Set OptionsEx.dgeFilterBar to True. The grid will display the filter bar where you can enter data for filtering.