SQL interface controls

[Martin Dew]

I have the task of creating a wizard type sql interface for our application.
I have already built an sql/report mechanism into the app that works by just
passing an sql statement through our middle tier then responding with the
resultset.

My next task is to create some form of wizard that enables the user to
easily build an sql statement, this way they do not need to learn sql syntax
to perform statistics on the database. I have to admit I am completely
stumped on this and would appreciate any input from experienced users as to
how to go about doing this, ideas on class structures that could be used
etc.

thanks for any help anyone can offer.

Martin

[Cezary Nolewajka]

Hi,

If you are using the SQL Server platform, you might consider the English Query server component.
It lets you define the metadata of a database and use english language for querying the database.
That might help your users.

--
Cezary Nolewajka
mailto:c.*********************@no-sp-am-eh-mail.com
remove all "no-sp-am-eh"s to reply
"Martin Dew" <re************************@adastra.co.uk> wrote in message news:ez**************@TK2MSFTNGP09.phx.gbl...

I have the task of creating a wizard type sql interface for our application.
I have already built an sql/report mechanism into the app that works by just
passing an sql statement through our middle tier then responding with the
resultset.

My next task is to create some form of wizard that enables the user to
easily build an sql statement, this way they do not need to learn sql syntax
to perform statistics on the database. I have to admit I am completely
stumped on this and would appreciate any input from experienced users as to
how to go about doing this, ideas on class structures that could be used
etc.

thanks for any help anyone can offer.

Martin