PRODUCT -> 1KEY -> 1KEY QUERY DESIGNER

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 :

1. Visual Interface to design queries
2. Creation of links with simple drag & drop functionality
3. Automatic SQL Statement Generation
4. Localization - option of specifying own parameters
5. SQL parsing - enter the SQL statement, and the diagram and grid gets populated.

1.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.

2. SQL Pane : Automatic SQL Statement generation : 1KEY Query Designer provides with results of the executed Select Query.

3. 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