Click to See Complete Forum and Search --> : Looking for a SQL build Control


DongNing
November 8th, 1998, 11:46 PM
hi:

I have been looking for a "standard SQL sentence build control"

for a long time.Can you help me to find it?

this control must :

1.have a visual interface to let my application' user to build SQL by select

table,field etc...(just like user build query in the Ms_Access).Table's name

and field's name is accommodated by my program dynamically in run time.


2.can "read" a SQL particular into it's interface.So my application user can

modify their sql particular having been created by a visual style.


Please note:I just want that this control can build sql in my

application's run-time for my application's user, Not in the programming

design time for myself(or say:for programmer).


I know there are some database controls which can build SQL sentence

.but they just transform a English sentence into SQL.(like Access

ELF )however

I want my application's user can build SQL through control's interface by

click mouse

(through selecting "table" ,"field" ,"query condition",and input some key

word

etc...most like what we can do when we build a query in ms_access).


thank for reading my mail,more thanks for answering my

question.


DongNing


email:Dong@bd748.pku.edu.cn