New Data Source and Object Filtering Features

Rapid SQL delivers three new filtering capabilities most requested by our customers. Simple, name-based filtering lets you filter data sources based on naming. When typing characters in the data source explorer and object list filter boxes the list is updated to show only matching objects. Complex, user-defined object name filtering lets you create your own custom filters at the data source level. And Node filtering lets you hide and show objects based on object type. These new filtering enhancements enable developers to better control the user interface and work more efficiently.

Enhanced ISQL Editor

The ISQL editor in Rapid SQL 7.7 has been enhanced to meet the challenging needs of the database developer. The ISQL editor now supports “on-the-fly” syntax checking of both your code as well as the object names. To further reduce the possibility of keying errors, Rapid SQL 7.7 introduces two other powerful functions; full object look-up throughout the SQL statement, and code complete. With code complete, Rapid SQL will dynamically walk you through statements, prompting you with dropdowns, to ensure proper syntax is used.

Data Source Management

New data source management features helps streamline workflow and simplifies data source management. Data source categorization lets you visually distinguish servers used for different purposes in your enterprise. And new import and export capabilities makes it easy to quickly export and import registered data source information so you can capture data source information for backup, migrate them to other machines, or share data source information with others in your organization.

Unicode Support

In today's global environment, when data is passed over different continents and different languages, Unicode is the internationally recognized method to support global data. Rapid SQL 7.7 now offers full Unicode support throughout the application, allowing you to work with data in different languages and display the text correctly on screen.

InterBase and Firebird Support

The Rapid SQL 7.7 release introduces seamless support for InterBase and Firebird with connectivity, object management, SQL editing and execution facilities, and project support.

Data Editor

Improvements to the data editor include simplifying record creation and default value handling to quickly add multiple records.

User Interface Enhancements

Rapid SQL 7.7 continues the ongoing efforts to standardize object editors and wizards to improve workflow and the user interface experience.

Additional Enhancements

• Object management enhancements for Oracle, DB2 z/OS, DB2 LUW, and SQL Server
• Enhanced currency and support for DB2 z/OS and LUW
• Windows 7 support