hi, i am fresh grad and wondering whether this idea can be done..
i have 1 ComboBox and 2 ListBox. ComboBox contain list of table, when user select a table, it will list the field name for selected table in ListBox1. The ListBox2 will list the selected field name by user. It will display in list box with this format "tablename.fieldname". So far i have done until this.
Now i am wondering whether can create SQL statement for each table in ListBox2 (the selected field by user).
- example: if it have 5 tables, it generate 5 sql statement. The field name is the field which was selected by user.
- In ListBox2, it can have more than 1 table and more than 1 field for each table.
- No join statement
Objective: I want to allow user dynamically create sql statement, by allow user to select table name and field name.
So is it possible for the above to be done? if yes any help or any idea how to achieve that............
|