|
1KEY Query Designer provides the facility to u se simple graphical interface to build SQL statements and create views in a database. It includes graphical panes that display your SQL statement visually and a text pane that displays the text of your SQL statement. You can work in either the graphical or text panes.
|
Key Features include
- Visual Interface to design queries
- Creation of links with simple drag & drop functionality
- Automatic SQL Statement Generation
- Localization - option of specifying own parameters
- SQL parsing - enter the SQL statement, and the diagram and grid gets populated
|
Visual interface to design queries & Create Links with drag and drop
You can easily specify which fields you want in your query by selecting them with a checkbox next to field name. 1KEY Query Designer will create link between tables with relationships in the database. You can also create your own links by dragging a field from one table to another field.
Link options and table options are showcased above
SQL Pane : Automatic SQL Statement generation
1KEY Query Designer provides with results of the executed Select Query.
Results Pane: Data Output in 1KEY Query Designer
1KEY Query Designer provides with results of the executed Select Query.
For further details sales@maia-intelligence.com
|
