外围海尊体育足球网

What's new in the Active Query Builder version 1.7.9?

·   Localization

o      Chinese, Czech and Italian localizations are added.

·   SQL Parsing Engine

o      Support of synonyms in Oracle is implemented.

o      Join object hints in MS SQL Server are supported now: WITH (nolock, repeatableread, ...).

o      MS SQL ranking and aggregate window functions and Oracle analytic functions are supported now.

o      Sub-queries in WITH clause now have support of field's aliases.

o      More precise erroneous token reporting.

o      Minor fixes in most of supported SQL dialects are made.

·   SQL Text Builder

o      Several bugs are fixed.

o      The new property is added to control format of the ORDER BY clause:

§         VCL Edition: TSQLBuilderSelectFormat.OrderByFormat.NewLineAfterItem

§         ActiveX Edition: ISQLBuilderSelectFormat.OrderByNewLineAfterEachItem

·   Metadata Container

o      New properties are added for fields to be stored in the Metadata Container: Size (Integer), Precision (Integer), PrimaryKey (Boolean), Nullable (Boolean), ReadOnly (Boolean). They are filled according to database structure and can be saved to XML file. ^*

o      ActiveX Edition: New properties are added for fields to retrieve data type: IMetadataField.DataType, IStatsUsedColumn.DataType, IStatsOutputColumn.DataType. ^*

·   Miscellaneous

o      The new (missing) properties are implemented to set width of query structure and database object trees:

§         VCL Edition: TreeOptions.TreeWidth

§         ActiveX Edition: TreeOptions.TreeWidth and TreeOptionsMetadata.TreeWidth

o      VCL Edition: AbsoluteDB Metadata Provider is implemented. ^*

o      Several memory leaks are eliminated.

Active Query Builder 1.7.9 版更新信息：