4D v11 SQL, 4D's newest version, breaks all previous limits to provide professional developers a set of integrated tools that are faster, higher performance, more productive and more open than ever before.
With 4D v11 SQL, both new and existing 4D applications will immediately benefit from:
• Improved performance of the new database engine
• Mac OSX Universal Binary architecture
Even better, they'll see these benefits without needing to make any changes to existing code.
Thanks to a dramatic increase in database storage capacities, 4D v11 SQL allows you to anticipate and meet the ever-increasing data requirements and performance expectations for enterprise solutions without a problem.
Finally, 4D v11 SQL breaks all the limits in cross-platform and cross-database communication: with a new native SQL engine integrated into the core of its architecture, and tighter implementation of XML and Unicode, 4D v11 SQL is the most open of all previous versions of 4D, allowing you even more options in software development and data integration.
Below are the main new features and improvements of 4D v11 SQL Release 1 (v11.1). The complete description is available in the 4D v11.1 Addendum on the documentation page. Bug fix lists can be found on our FTP site.
4D v11 SQL Release 1 (v11.1) is certified for Mac OS X Leopard, the latest version of Apple's Macintosh operating system (10.5.x).
In addition to English, French, German and Spanish, the 4D Installer now offers the option of Japanese. Developers in Japan can now upgrade their existing applications from 4D 2004 and start using the more than 200 new features of 4D v11 SQL. Full support of Unicode at the core level allows Japanese usersto handle native data and easily create ergonomic interfaces.
The new 4D v11 SQL engine embeds a query analyzer and optimizer that automatically decides on the most accurate and swift way to perform the query. For example, 4D could change the order of sub-queries designed by the developer or avoid using an index if the scope of records is reduced. With 4D v11 SQL Release 1 (v11.1) you can extract — as a text or XML file — and compare the query project envisaged by the engine with the actual path of the query once executed including the detailed performance result. Thus, the developer can analyze and optimize their query procedures undertaken through 4D language as well as SQL sentences.
Unicode compatibility has been included in the 4D View plug-in and in the menu management, thus allowing elegant interfaces with different alphabets to be used in the same menu.
4D developers usually launch their queries without case-sensitivity, which means that a search carried out with 4D language on "ABC" returns "Abc," "abc," àbç," etc. By default, SQL syntax does not allow this behavior, and some unexpected results may be generated when using both approaches. Now a new option allows for activating or deactivating this feature on the fly in SQL queries.
4D pointers can be used in SQL queries, which enhances integration of SQL language in 4D Methods and widens the use of SQL in the code's generic parts.
4D Quick Reports can be printed in a smoother way because the report editor and the main application share now the same print settings. This allows merging reports into a global printing task with a single printer setting.
International |
Company | Contact
4D | Site Map | Privacy
Policy | © 4D UK 1995-2008 | Change font size: [A]
[A]
[A]
| 
Product Line Overview