Query by example mode?
Posted: 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
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