Embarcadero Technologies Home | Technical Support
Embarcadero Rapid SQL Developer simplifies SQL development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools help streamline coding tasks. Rapid SQL Developer’s user interface helps improve overall productivity with database object look up functionality and side-by-side views of application code and SQL code. Power SQL offers native support for IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server and Sybase® as well as JDBC support for other DBMS. Rapid SQL Developer is available as a stand-alone application or as an Eclipse plugin.
What's New in Rapid SQL Developer 2.0
Enhancements to Data Source Explorer
Text File Encoding (Unicode Support)
Release Notes
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
What's New in Rapid SQL Developer 2.0
Improvements to SQL Editor
Code Quality Check and Code Assist functionality have been improved in Rapid SQL Developer 2.0 to provide further comprehension and more fluid code development while working in the environment:Debugging Functionality
Rapid SQL Developer now features a fully-contained debug process, for the purpose of debugging stored routines in the development environment prior to execution. The debug process is managed via the Debug view, and enables users to manage common debug functionality such as breakpoints and step over, as well as providing variable and dependency views. Additionally, Rapid SQL Developer fully supports cross-platform debugging, which enables you to debug SQL procedures embedded inside Java code.Enhancements to Data Source Explorer
Rapid SQL Developer 2.0 provides enhancements to Data Source Explorer. This includes improvements to auto-discovery and import functionality, search, and filtering functionality.SQL Templates
This version of Rapid SQL Developer introduces a selection of 267 fully-customizable code templates that enable developers to select a DML or DDL statement schematic and drop it into SQL Editor. Placeholder syntax can be replaced manually with statement variables, or otherwise customized to meet development needs.Data Source Indexing
The Data Source Cache has been renamed the Data Source Index to better reflect the nature of its functionality. In addition to the name change, it has been greatly improved and provides faster indexing, as well as automatic incremental updating on CREATE, ALTER, and DROP statements, and indexing options that enable users to specify indexing for individual data sources.SQL Execution
The SQL execution process has been enhanced to provide more comprehensive Result views. This includes the ability of a user to select different file format options when viewing and saving execution output results.Text File Encoding (Unicode Support)
Rapid SQL Developer 2.0 provides options for changing the file encoding format used when saving text files. You can set encoding formats globally, or for specific files, or groups of files within the development environment.SQL Server 2008 Support
Rapid SQL Developer 2.0 provides full support for SQL Server 2008. This includes syntax, compound operators, new data types, Dynamic Management Views, and Functions.Release Notes
Important Advisory Notes
Rapid SQL Developer can be installed as a standalone application (RCP installation) or as an Eclipse plug-in (Plug-in Installation). Eclipse is an open source development framework that supports application plug-ins to provide additional functionality.
The Eclipse plug-in version of Rapid SQL Developer requires Eclipse version 3.3 or higher, and Sun Java Standard Edition 5.0 Update 11 or later in addition to regular system requirements.
Before installing the plug-in version of Rapid SQL Developer, ensure that Eclipse and Java is installed on your machine. You can download Eclipse from the following Web site: http://www.eclipse.org/downloads.
Known Issues
On SQL Server 2005 and 2008, views cannot be dropped successfully in Data Source Explorer when using the Drop wizard available via the Drop context menu of the view. This issue can be resolved by dropping a view manually.
Execute the following script in SQL Editor to manually drop views:
Bug Fixes
| Bug | DBMS | Version | Description |
| 7216 | All | All | Application freezes if connecting to a slow data source and opening a SQL file at the same time. |
| 7215 | All | All | Embedded comments not terminated correctly causes error. |
| 8236 | Sybase | All | Code Assist doesn't pop up column names after user type "." in where clause. |
| 8290 | Sybase | 12.5.4 | Explain plan cannot be computed for the select statement. Reason: Invalid column name 'N'. |
| 6553 | SQL Server | All | SQL_Execution: Error returned when specifying Korean language table name - SELECT * FROM db.tbl. |
Additional Resources
Licensing Your Embarcadero Technologies Product
This product includes a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.
Embarcadero Technologies Product Support
The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase.
Go to www.embarcadero.com/support or click any of the links below to find:
Embarcadero Technologies Technical Support
If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).
We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.
Embarcadero Technologies on the Web
To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.