Automatic SQL query builder
From: Jaroslaw Tomczak <Jaroslaw.Tomczak_at_CCC.Chemie.Uni-Erlangen.DE>
Date: Wed, 10 Oct 2001 16:08:30 +0200
Message-ID: <3BC4565E.E87B2138_at_CCC.Chemie.Uni-Erlangen.DE>
Hi,
Date: Wed, 10 Oct 2001 16:08:30 +0200
Message-ID: <3BC4565E.E87B2138_at_CCC.Chemie.Uni-Erlangen.DE>
Hi,
As a part o bigger project I develop a kind of automatic query builder.
This application receives as input:
appropriate tables and desired values
In trivial cases it is quite easy to analyse the above input and build
appropriate queries, but many problems arises when one tries to
implement joins and subqueries.
I'm simply looking for some papers, reports, links that would relate to
the problem described above.
1. A list of search criteria -- field names, their locations within
2. A list of fields that should be returned by query
3. Fields used for sorting results
4. Description of tables' relationships.
As the results the application returns a correctly formulated SQL query.
Thank you in advance,
-- ;; Jaroslaw Tomczak (let ((Computer-Chemie-Centrum 'http://www2.ccc.uni-erlangen.de)) (visit Computer-Chemie-Centrum))Received on Wed Oct 10 2001 - 16:08:30 CEST