FlySpeed SQL Query 2.9.1.1

FlySpeed SQL Query 2.9.1.1 is considered as a flexible and effective tool which is designed for the most of today's popular databases. It was primarily designed to meet the everyday needs of ordinary database users who need to work with data first and foremost, rather than to design databases. It allows you to build queries on many different database servers without needing deep knowledge of SQL syntax and to work with data fast and easy.

FlySpeed SQL Query tool facilitates the process of building SQL by letting you quickly drag and drop tables to create queries, from simple to complex, and combine visual query building with direct SQL text editing. FlySpeed SQL Query tool combines powerful means of working with SQL queries, high-speed data retrieval and one-click data export and printing to make your work with data more productive than ever before!

1. Wide range of supported database servers and desktop databases
   • Full support of SQL syntax for Microsoft SQL Server, Oracle, MySQL, Microsoft Jet 4 (MS Access, MS Excel), PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQLite.
   • Support of the other ANSI SQL/92, SQL/89 and SQL/2003 compatible database servers such as Teradata, Netezza and desktop databases (Paradox, FoxPro, dBase (DBF)).
   • Native connection to Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MS Access, InterBase/Firebird.
   • Connection to any other database via ADO or ODBC driver.
2. Common features
   • Simple and convenient graphical user interface.
   • High-speed data retrieval.
   • Full Unicode support.
   • Portable installation to work from a USB Flash drive.
   • Read-only mode for selected connections.
3. Simple and convenient database object browser
   • Quick access to all data-contained database objects.
   • Saving queries to connection's object browser.
   • Database objects and queries incremental search and filtration.
4. Easy SQL query building and fast data browsing
   • Easy-to-use visual query builder to build even complex queries.
   • Dragging objects and saved queries to the query builder.
   • SQL Editor with code completion and syntax highlight.
   • Data browsing in Grid and Form modes.
   • Advanced BLOB browsing and editing in various formats.
   • Quick data sorting and filtration.
   • Totals calculation: summarizing and other aggregate functions.
   • Copying selected records to clipboard.
   • SQL query statistics and execution history.
5. Advanced features (available in the Standard version only)
   • Exporting data to most popular office formats with ease. (MS Excel (.xls), OpenXML (.xslx), CSV, Text, HTML and XML)
   • Printing and exporting data to PDF in a few mouse clicks.

• ODBC connection form is updated: 
• • "Launch ODBC Administrator" and "Create new ODBC DataSource" buttons;
  • Connection Timeout and Command Timeout are moved to additional props;
  • Username and Password can be saved now in connection properties.
• Moving connection queries on changing Global queries path is made.
• Ability to cancel moving queries to a new location is made.
• The Global Query Path is stored relatively now if set to default folder or it's sub-folders.
• The "Set to default folder" button is added to the Options dialog.
• On changing the Portable mode setting the user is asked to move the Saved queries to appropriate location.
• Execution of SELECT statements only is allowed in Read-only mode.
• MS Access and MySQL Login Prompt dialogs are back.
• The bug with incorrect creation of sub-folder in the queries folder is fixed.
• Unnecessary query builder update on executing SQL Query is removed.
• Memo fields were not exported to OpenXML format. Fixed now.
• Timestamp fields export to MS Excel error is fixed.
• Passwords were saved in connection properties despite of the "Save password"  setting. Fixed now.

• Java, .NET, ActiveX and Delphi (VCL)