Board index » delphi » [?] Howto create a generic ADO Search ?

2005-08-12 09:58:17 PM
delphi161
Hi,
I'm searching for a component / source code to make a generic search for
ADO datasets.
I've found some old components, TDBNavigator descendants, but they works
only with BDE Tables, not with ADO.
I'm trying to extend TDBNavigator from myself, but it is not so easy...
May be a possible way is to create some tedit at runtime over TDBEdit in
the form and apply filter on TADODataset ( Table or Query)...
Does anybody share this idea ? ( or can give some better idea, obviously...
;-))
Thanks.
 

What do you mean by "generic search for ADO datasets". You do a
"findcomponent" loop and check for components of type 'tadoquery or
tadodataset
 

You may use the freeware TSMDBFind component:
www.scalabium.com/smdbfind.htm
This component works with any dataset including ADO
"Moreno" <XXXX@XXXXX.COM>writes

Filtering is a very bad idea if you are working with a database server
because the filter occurs on the client. That means that all of the
data must be copied from the server to the client where the records
that do not pass the filter are dropped. This causes poor performance
and very high network traffic.
What database are you using and what, exactly are you trying to do.
--
Bill Todd (TeamB)
 

I would like to have a component or a procedure that allows user to
search between records in current data form.
I don't want to create a specific search form for each data form in my
application.
If I want catch the data fields visible in the form and allow user to
digit the values to search.
I don't want to do this for a specific DB.
Bill Todd writes:

I am not aware of any component that does what you want. You may have
to write it yourself. The most generic way to implement such a search
form would be to use ANSI standard SQL for the search.
--
Bill Todd (TeamB)