Re: Relational Database Searching

I assume by "recordset" you mean an ADO or DAO recordset.

For such a nonspecific requirement, perhaps you should provide a graphical query-builder tool. That would let a user "basically search the database for any information, in any of the tables with any conditions".

MS-Access is such a query-builder tool that you could script and get a recordset. Other software I know of is RapidSQL from Embarcadero or R&R Report Writer SQL Edition from Liveware, but I don't know if their stuff will return you a recordset.

Don't reinvent the wheel.
- cb

"DrLargePants" <sean.connolly_at_bigfoot.com> wrote in message news:758bb9a6.0204250242.5462238b_at_posting.google.com...
> We have a database that contains tables for clients, preferences,
> orders, payments etc etc. We want to provide a business object in vb
> that allows a client program to basically search the database for any
> information, in any of the tables with any conditions.
>
> Basically I want to provide a search function, that has table names,
> and field names as parameters (or as a property bag), as well as
> operators (>,< >= etc), which returns a recordset containing the
> result.
>
> I can do this reasonably easily using a huge case statement that
> builds up the query string with the where clause (choosing the join
> type might be a bit tricky) and then executes the query and returns
> the recordset. However, I was wondering if there was a more elegant
> way of doing this using a third party tool or some other method (I
> don't really want to write a twenty page case statement !)
>
> Any input at all would be most gratefully received !.
>
> S.
Received on Thu Apr 25 2002 - 20:28:38 CDT