Re: Front Ends for Non SQL Users

> We're trying to come up with some nice fromt ends to our ORACLE customer
> repositories which will allow marketing people the ability to write
> queries against the DB without SQL knowledge. We are looking at tools
> like Data Browser, IQ, Delphi, etc. We envision a search routine along
> the lines of "Customer Balance>1000 AND Behavior score < 400..."
>
> We had developed some of this on Gupta SQLWindows, but have decided that
> there must be a better way.
>
> Any opinions out there?
>
> Thanks, Bill Hungerford
>
>
>>>>

Well, I am a VB/Oracle programmer/analyst conslutant (sic), and if I were given this requirement in a project, I would:

1. create a combo box of tables (sorted) I want to expose to the user
2. once the table is selected (make or translate actual table names into entities that a lay user would understand), retrieve the col names into another combo box.
3. for each col selected by the user, allow the user to pick the comparison operator from an option frame, have the user enter the comparison value in a text box, choose AND/OR, etc. from another option frame.
4. build the information gathered into a SELECT SQL and execute it with OO4O data control tied to a Truegrid.

Should take only a few hours to code this one up.

Enjoy!

---------------------This is my signature file!---------------------
xxxxxxxxx  xxxxxxxxx  xxxxxxxxx  x       x  xxxxxxxxx   xxxxxxx     
x              x      x          x       x  x          x       x    
x              x      xx         x       x  xx         x            
xxxxxxxxx      x      xxx         x     x   xxx        x            
        x      x      xx           x   x    xx         x            
        x      x      x             x x     x          x       x    
xxxxxxxxx      x      xxxxxxxxx      x      xxxxxxxxx   xxxxxxx    x
--------------------------------------------------------------------