Working with Query Manager

Working with Query Manager

Select Database

You have to select database name from available database list.

New Model

Model means query.Here you can define new model.

Save Model

You can save the current query.After clicking on Save Model, message will be displayed "Do you want to prepare SQL ",click on Yes if user has not modified the generated query after clicking on Generate SQL option.click on No if user has modified the query manually after clicking on Generate SQL option.

At the end user has to provide query name to save the query.

Show Table

Show table will invoke the empty text box where list of tables will be displayed.

Load Table

Load table will load the tables from selected database.

example:

Customers

Employees

Orders

Orders Detail etc..

Generate SQL

Before Generate SQL user has to select the table(s) [ Drag & Drop ] & has to select required columns then only Generate SQL  will  generate the SQL statement.

For example if user has selected Customer table and  ticked on * than clicking on Generate SQL following SQL statement will appear on bottom.

Select * from Customer

or

If user has selected

example:  Ticked on ( ü ) Customer id , Fax, Phone , Address  than after clicking on Generate SQL following SQL Statement will appear on bottom.

Select  Customerid, Fax, Phone, Address  from Customer

Run Current SQL

Run Current SQL will execute the current SQL statement  & show the data on the bottom of screen.

User Guide 14