Query by example mode?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
uko
Posts: 14
Joined: Tue 16 Sep 2008 12:27

Query by example mode?

Post by uko » Sat 08 Nov 2008 22:29

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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 10 Nov 2008 08:36

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.

Post Reply