MX Query Builder features

Dreamweaver Integration

• The MX Query Builder visual editor can be launched directly from Dreamweaver.
  
  

• MX Query Builder generates recordsets that can be used directly in Dreamweaver, as sources of dynamic data.
  
  

• Queries are saved as advanced recordsets.
  
  

• MX Query Builder recognizes and uses the database connections you define in Dreamweaver.

• Recordsets created with MX Query Builder can be used with other server behaviors and commands from Dreamweaver or from MX Kollection 3.

• Queries edited in the Visual Editor are automatically recognized and loaded in Dreamweaver, on saving.

User-friendly Interface

• The Visual Editor window was redesigned to match the new InterAKT look & feel.

• The Visual Editor interface was split in 5 panels to make it more ergonomic:
  · Query List Panel
  
  
  
  · Tables Panel
  
  
  
  · Database Diagram
  
  
  
  · Query Management Panel
  
  
  
  · SQL/Results Preview Panel
  
  

• We added Help buttons for each panel.
  
  

• We added tooltips for all elements in the Visual Editor.

• Queries can now be managed directly in the Visual Editor (in the Query List Panel).

• Contextual help was added to the interfaces, to guide you through using the product.

• View query results directly in the Visual Editor, as you work.

• Support for keyboard shortcut keys.

Creating and Editing Queries Visually

• Create, save and delete queries on the spot in the Visual Editor.

• Create new queries from existing ones.

• View the diagram of your query and edit it visually, in a point and click approach.

• View table columns and data types directly in the diagram.
  
  

• Select tables and columns that will be included in the query visually.

• Contextual menus for managing database diagrams.
  
  

• Drag and drop tables to arrange them in the diagram.

• Visually define relations between tables using drag and drop between table columns.
  
  

• Use aggregate functions, such as sum, max and min.
  
  

• Define complex conditions on table columns.
  
  

• Extract information from multiple tables.

• Sort records in ascending or descending order.
  
  

Improved Database Model

• Visual representation of table relations, with arrows to indicate the type of JOIN.
  
  

• You can select the columns that will be included in the query directly from the database diagram.
  
  

• You can select all columns of a table automatically, just by clicking a checkbox.
  
  

• Get a bird's eye view of the database diagram using Zoom out or concentrate on diagram details using Zoom in.
  
  

• Print database diagrams and query results directly from the Visual Editor.
  
  

• Duplicate tables and create self-relations.
  
  

Productivity

• No SQL knowledge required.

• Queries stored in the repository can be reused and edited.

Generated Code

• View generated SQL code directly in the Visual Editor, as you work.
  
  

• Automatically writes SQL conditions code.
  
  

• Automatically add GROUP BY construct for aggregated fields.
  
  

• Generated SQL code is error-free.

• Generated code is SQL '92 compliant.

Compatibility

• Multiple browser compatibility: Microsoft Internet Explorer 6.0+, Firefox, Mozilla, Camino.

• Multiple database compatibility: MySQL, PostgreSQL, Access 2000, and Microsoft SQL.

• Support for PHP_MySQL server model (ColdFusion, ASP_VBScript, and PHP_ADODB server models will be added soon).

• Works on Windows and Macintosh (with Mozilla installed for Macintosh users).

Documentation

• Integrated Dreamweaver help (search, index, glossary).

• Step by step tutorials with real-life applications.

• Comprehensive user manual.