What's New In Advantage 12

New Client

Advantage Delphi OData Client

Added a new Delphi based client that consumes OData and allows developers to interact with the data using familiar TDataSet data store. Applications developed using this can be deployed across platforms, using Embarcadero's cross-platform technology.

Updated Support for Clients

Delphi XE8 Support

The Advantage Delphi Components now include support for Delphi XE8.

Visual Studio 2013 Support

The Advantage .NET Data Provider now includes support for Visual Studio 2013

PHP 5.5 and PHP 5.6 Support

The Advantage PHP Extension is now available for PHP 5.5 and PHP 5.6

New Features and Enhancements


Added support for the GROUP_CONCAT() aggregate function. It is used to combine string values in a group into a single string value. This provides a nice mechanism for producing a result set where each row contains all values for a single group in one string.

Multi-row INSERT Syntax

With support for multi-row INSERT statements in SQL, it is possible to write a single SQL INSERT statement that inserts multiple rows into a table.

Improved Scalar Functionality

Additional scalar functions are now supported in both SQL and navigational environments. This can enable better optimization for SQL statements in some situations. Additional scalar functions now supported in SQL statements include ALLTRIM, AT, CTOD, CTOT, CTOTS, DATE, DELETED, DTOC, DTOS, RAT, RECNO, REVERSE, STOD, STOTS, STR, STRZERO, TIME, TSTOD, TTOC, and VAL. Additional scalar functions now supported in navigational usage (as index expressions) include ASCII, CEILING, COALESCE, CREATETIMESTAMP, DIFFERENCE, FLOOR, FRAC_SECOND, LENGTH, REPEAT, SIGN, and SOUNDEX.

For example, it is possible to refer to a specific record number directly within SQL now:  SELECT * FROM table WHERE recno() = 123

Other new scalar functions include:




Performance Improvements

Sped up parsing of expressions.  This, among other things, improves building filters for SQL optimization.

Sped up expression evaluation for situations when optimized bitmap (AOF) filtering cannot be used.

Reduced memory consumption in the cache system. In particular, static SQL cursors involving memo files by about 33%.

Increased performance of Online Reindex and removed the transition during the final stage.

Improved the performance of queries involving extremely large intermediate sort files.

Create Index Online

Added the capability to create indexes while a table is open by other users.  Prior to ADS v12 it was necessary to open a table exclusively (thus disallowing any other use of the table) when a new index is created.  See Online Table Maintenance for more information.

Archive File for Online Backup

Updated the online backup/restore functionality to be able to backup to and restore from a single archive file that can optionally be compressed. This makes it simpler to move or copy a backup image to other locations (just copy a single file). Search for the ArchiveFile option in Backup and Restore Options.

Improved Differential Online Backup

Updated the operation of differential backups. A differential backup is a backup that copies only records that have changed since the last backup. In previous versions of Advantage, it was required that you re-initialize the differential backup when certain operations occurred (packing of a table, altering a table, etc.). Beginning with v12, Advantage will detect if a differential backup for a given table requires re-initialization and will automatically perform it. In addition Advantage will now detect if indexes in a free table differential backup have changed and automatically backup the changed indexes.

Memo Block Size Configuration

More options exist for configuring memo block sizes on tables:

The maximum memo block size for ADT tables has been increased from 1024 bytes per block to 32768 bytes per block.

The memo block size of an existing table can be changed through a pack operation (sp_PackTable, sp_PackTableOnline, AdsPackTable120).

The memo block size of an existing table can be changed when altering the table (ALTER TABLE, AdsRestructureTable120).

When creating a new table with SQL, the memo block size can be specified (CREATE TABLE).

When modifying table properties in Advantage Data Architect, the memo block size for both data dictionary and free tables can be modified. Note that when the OK button is pressed on the property dialog, a table restructure operation will be triggered if the memo block size property was changed.

Improved Memo Recycling

The ADT table type now has an improved recycling scheme for memo files.  This scheme will reduce memo file bloat by using a binning algorithm for small memos.

AdsFileToBinaryW and AdsBinaryToFileW

AdsFileToBinaryW and AdsBinaryToFileW allow Unicode filenames to be used as the source and destination for these APIs.  See AdsFileToBinary and AdsBinaryToFile for more information.

Memo and Blob Compression

The ADT table type now has the option to store memo (ANSI and Unicode) and blob data in compressed format to reduce memo file size. See ADT Field Types and Specifications for more information.

Option to Disable Compression of Dump Files

If Advantage Database Server triggers the creation of a crash dump file, it compresses the dump file. The compression step can be relatively slow compared to the creation of the dump file in the first place. The new COMPRESS_DUMP_FILES configuration option provides the capability to disable the compression step.

Improved Online ALTER TABLE

Improved the behavior of Online ALTER TABLE to not require all users to close the table for for most types of table changes.  Some table structure changes do still require all users to close the table for the online ALTER to finish.  Also changed online ALTER to set default field values and NOT NULL flags for added fields before populating the new table with the existing data.  The result is that you can now add a field and initialize it with a default field value during an online ALTER.  This applies to dictionary bound as well as free tables.  See Online Table Maintenance for more information.  As a result of these new features, a checkbox has been added to the table designer in Advantage Data Architect to cause changes to a table to be performed online.

Maximum Failed Login Attempts for All Remote Server Connections

Previously Advantage only enforced the Maximum Failed Login Attempts for Internet Connections.  A new option has been added to the data dictionary to have Advantage enforce the Maximum Failed Login Attempts limit for all remote server connections.  See Maximum Failed Login Attempts for more information.

ETag Support for the Advantage Web Platform

The OData server supports optimistic concurrency through Entity Tags (ETag) values. If you set the TABLE_CONCURRENCY_ENABLED property for a table (e.g., in Advantage Data Architect in the table properties), then OData clients that support ETags such as the Advantage OData Client for Delphi and the Windows Communication Foundation (WCF) client will use ETag values in If-Match headers to for optimistic concurrency control.

GUID and 64-bit Integer Field Types

Advantage server and clients now support GUID and Long Integer (64-bit) data types in all table formats. The 64-bit integer type can be used to store integer values between -9,223,372,036,854,775,807 and 9,223,372,036,854,775,807 with no loss of precision. The GUID (Global Unique Identifier) field type is a 16-byte data structure. A new scalar function NewID() is available in the expression engine and SQL engine to generate new GUID. See ADT Field Types and Specifications and DBF Field Types and Specifications for more information.

Database Triggers

Support for database triggers has been added to provide the ability to fire triggers in response to certain types of events.

__rootdd System Alias

A system alias called __rootdd has been added which resolves to the path of the root dictionary configured for the server.  Connections to the root dictionary can then be made to \\server\__rootdd.

Added Max Login Attempt Enforcement for all Remote Connections

Previously the max login attempts enforcement only applied to internet connections.  A new database property (ADS_DD_ENFORCE_MAX_FAILED_LOGINS) has been added which when enabled will enforce the max login attempts for all remote server connections (including internet connections).  The property may be set on the Security tab of the Database Properties dialog in Advantage Data Architect or by calling AdsDDSetDatabaseProperty/sp_ModifyDatabaseProperty.

Added $select Web Platform Option

The $select URI option can be used to limit which columns of a collection are returned from a request.  See collections for more information.

  • SAP Moderator