Overview
4D Products
Features
Getting Started with 4D
Resources
Below are the main new features and improvements of 4D v11 SQL Release 1 (11.1). The complete description is available in the 4D v11 SQL Addendum on the documentation page.
4D v11 SQL Release 1 (11.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 (11.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, Inc. 1995-2008 | Change font size: [A] [A] [A] | 
| 4D RSS Feeds
