Change Logs | RemObjects Software

Changes in AnyDAC 2.0 for Delphi

This document lists the changes introduced by new versions of AnyDAC for Delphi.

New in the “Spring 2009” Release, Version 2.0.17 (Build .1267)

added: AD-0339: SQLite: Add static linking of SQLite3 amalgamation
added: SQLite: sqlite3_progress_handler support
added: ADConnection: KeepConnection option
added: MySQL: SSL connection support
added: AD-0335: MSSQL 2008: TIME2 support
added: AD-0328: ODBC, ASA: Add support for ODBC v 2 drivers.
added: GUIx: added TADGUIxFormsAsyncExecuteDialog.ShowDelay and HideDelay properties
added: TADGUIxFormsErrorDialog: StayOnTop property
changed: SQLite, Stan: optimized Array DML speed for 20%
changed: DatS: optimize streaming support to outperform the ADO. Now AnyDAC streaming is about 1.5 times faster on saving.
changed: TADTransaction.IsActive renamed to Active
changed: Phys: SYS and INFORMATION_SCHEMA are the osSystem scoped schemas
changed: GUIx: using Consts.SOK / SCancel for dialog buttons
changed: GUIx: OK button is not the default button of the error dialog
changed: ADConnection: SetTransaction is now virtual
changed: ADConnection: GetLastAutoGenValue reviewed, tested and few issues are fixed
changed: ADMetaInfoQuery: ResourceOptions is now published
fixed: SQLite: static linking installation fails
fixed: ODBC: Error with ODBC v 2 driver and MonitorBy=Xxx
fixed: GUIx: FormatOptions.MapRules editor was missing few data types
fixed: DataSnap: fails to post updates to MSSQL 2005 VARCHAR(MAX)
fixed: AD-0353: DatS / Phys: Fails to use GUID fields with AutoInc attribute
fixed: AD-0352: Stan: Expression evaluator fails to handle GUID values
fixed: AD-0351: Stan: XML storage may fail to save Boolean value
fixed: AD-0350: SQLite: Fails to convert GUID values on non-Unicode Delphi
fixed: ODBC: fails to recognize a driver kind and create correct metadata object
fixed: ODBC: fails to fetch blob values using Oracle and Firebird ODBC drivers
fixed: AD-0345: Access + ODBC / Driver-Version check raises AV
fixed: MSAccess: the Access 2007 driver raises "integer overflow"
fixed: MSSQL 2008: DATE data type support was broken
fixed: ASA: fails to recover broken connection
fixed: ASA: not all "disconnected" error are recognized as ekServerGone
fixed: PgSQL: the UUID support was broken
fixed: AD-0338: PgSQL: "DECLARE CURSOR can only be used in transaction blocks" with multiple TADTransaction's
fixed: PgSQL: not always correct cursors management in transaction
fixed: PgSQL & ADT: A number of fixes and improovements for PgSQL composite and general ADT data types handling
fixed: AD-0342: Oracle: fails to open a query with CHAR(...) parameters
fixed: AD-0334: DB2: Cannot properly detect Unicode columns
fixed: IB/FB: invalid variable label in a trace output
fixed: MySQL: fails to initialize embedded MySQL
fixed: Phys: when connection was recovered with active transaction, then exception may be raised on connection closing
fixed: Phys: AV is possible on canceling of the very fast queries
fixed: DatS: fails to load stream saved with v 2.0.13 version with "Cannot read DatSRow object"
fixed: DatS: fails to load a blob value from XML storage
fixed: ADMemTable: fails to load a stream with an custom extra table added to dats manager
fixed: ADQuery: AV is possible with ResourceOptions.ExecMode = amBlocking and ExecTimeout > 0
fixed: ADQuery: AV is possible, when an exception is raised (Open / ExecSQL) and the query is destroyed before exc. object
fixed: TADDataSet: impossible to post changes in OnBeforeClose
fixed: AD-0333: ADDataSet: Refresh of detail dataset makes current a first record
fixed: ADDataSet: fails to call NextRecordSet in AfterOpen in Async mode. And few other issues related to Async mode and multiple result sets.
fixed: ADStoredProc: changing param data type (AsXxxx) before Prepare call may lead to a parameter value loss
fixed: AD-0330: ADStoredProc: GetResults has no effect
fixed: ADUpdateSQL: AV is possible on destruction
fixed: AD-0329: ADUpdateSQL: AV at run time create / destroy
fixed: ADTransaction: may fail to destroy a dataset linked to a transaction
fixed: ADManager: TADManager.DriverDefFileName has no property editor.
fixed: AD-0331: ADConnection: OnError event handler may lead to "ADManager shutdown timeout"
fixed: AD-0349: ADParam: Assign(TParam) incorrectly assigns BLOB value
fixed: AD-0334: ADScript: fails to execute script with the phrase ESCAPE '\'
fixed: ADScript: ScriptOptions.CommitEachNCommands does not work properly
fixed: ADScript: BYTES / VARBYTES column dumping was broken
fixed: AD-0332: Stan: Mapping of dtByte to dtAnsiString / dtWideString fails
fixed: GUIx: QBuilder fails to load saved query model
fixed: ADExplorer: fails to work with some of connection definition settings
fixed: ADExplorer: fails to show foreign key columns
fixed: ADMonitor: the TADMonitor + MonitorBy=Remote leads to "interface is not supported"
fixed: AD-0337: DataSnap: ORA-01036 on posting updates to Oracle DB
fixed: AD-0336: DataSnap: "BCD Overflow" on Oracle "SELECT COUNT(*) from MyTab"
fixed: FPC: few FPC / Linux incompatibilities

New in the “Winter 2009” Release, Version 2.0.15 (Build .1163)

added: PgSQL: support for array and composite types
added: Firebird: supported for trusted authentification
added: MSAccess: support for INSERT INTO .. DEFAULT VALUES
added: SQLite: support for PRAGMA = FOREIGN_KEYS
added: AD-0315: GUIx: Add exception handling control to the TADGUIxFormsErrorDialog
added: TADDataSet: Add Distinct property to TADIndex
added: DatS: add versioning to the DatS streaming. Added TADResourceOptions.DefaultStoreVersion property.
added: ADExplorer: added support for connection recovery
added: FR4 addon: added D2010 package files, minor fix
added: Demo: TADScript demos are added
added: Help: TADScript is described
changed: TADScript: multiple improvement and code cleanup
changed: Phys: reconnection logic will be used for setting Connected to True
changed: Phys: Ping method may be used when connection is not active
changed: Phys: [IB|PG]ExtendedMetaData renamed to ExtendedMetaData. ExtendedMetaData is now False by default.
changed: Stan: Options implementation is reworked to make it possible to implement profiles, etc. Also, now it is few ten % faster.
changed: GUIx: "Advanced Options" captions are renamed into "Options". Few other similar changes.
changed: ADDataSet: dataset constraint error message now is more informative
changed: ADDataMove: in DS -> DS mode data move now will add to mapping only the same named fields
changed: better diagnostic for "factory is not found" error
changed: Tools: now is Unicode enabled
fixed: DApt: AV when monitoring is enabled and SchemaAdapter is using
fixed: AD-0324: PgSQL: 44000000 is fetched as 4400
fixed: AD-0322: ADQuery: Does not post update for a field change 0.5 -> 0.05
fixed: MySQL: stored procedure may fail to return data correctly
fixed: Oracl: the support of inserting into a field with a sequence in a trigger was half broked
fixed: MySQL: BIT(1) is mapping to dtByteString, instead of dtBoolean
fixed: Oracl: does not support ftBoolean parameters
fixed: GUIx: syntax memo does not correctly use the Delphi syntax highlighting schema
fixed: AD-0321: ADDataSet: CopyDataSet may raise AV
fixed: TADConnection: ExecSQL and ExecSQLScalar do not route an error to the OnError event
fixed: AD-0320: ADDataSet: TField.OldValue, NewValue and CurValue does not work in TField.OnValidate
fixed: AnyDAC may fail if to compile with different aligment, than {$A8}
fixed: MySQL: stored procedure does not support BINARY / VARBINARY parameters
fixed: AD-0319: ADQuery: Multiple issues with dataset editing, locking and transaction handling
fixed: TADDataSet: "Out of bounds" if add a fkInternalCalc field after creating the normal fields
fixed: AV in ADScript when connection is losted
Oracle, MySQL, etc: fails to fetch date column with year < 1900
Oracle: fails to fetch date column with year < 1900
fixed: TDBX: fails to fetch resultset with ADT columns ("invalid attribute" on Oracle)
fixed: ADScript: incorrect error message when command unit is not linked
fixed: AD-0316: DatS: Constraint checking does not work on the long string columns
fixed: Conn edit: incorrect links to the wiki
fixed: ADScript: incorrect error message when command unit is not linked
fixed: AD-0313: Design time: "TByteField class is not found" exception
fixed: AD-0312: FB: Some procedures are not shown for StoredProcName
fixed: Installer: fails to detect environment with "invalid data type for 'Xxxx'"
fixed: AD-0286: Installer: Fails to install on D2010 Prof
fixed: Installer: fails to compile with undefined AnyDAC_MONITOR
fixed: D7: Internal error: E5916 on ADConnection.Connected := True
fixed: AD-0285: TADDataSet: Post/Next statement leads to an infinite loop
fixed: TADDataSet: assertion is failed if to call Cancel from BeforePost
fixed: TADDataSet: GetNextPacket returns 0, while there were records fetched
fixed: AD-0290: TADDataSet: FetchAll does not refresh the DB-controls
fixed: AD-0294: ASA: AnyDAC fails to connect to ASA v 11
fixed: MSAcc 2007: "Syntax error in INSERT INTO statement" with TEXT column
fixed: ADS: few issues
fixed: ADS: does not support SQL_C_NUMERIC
fixed: AD-0307: Oracle: "Variable length data column [DUMMY] overflow" on connection transfered to DLL & UTF8
fixed: IB: "Unavailable database" is not recognized as a losted connection
fixed: AD-0288: IB: Setting IBAdvanced=set_db_readonly=0 does not work minor changes for DBX bridge driver
fixed: AD-0305: PgSQL: CurrentSchema returns invalid data. So, metadata is not returned correctly too.
fixed: AD-0296: PgSQL: "Cannot parse object name" is raised on a query with sub-queries
fixed: AD-0295: MSSQL: Wrong TEXT value fetched from a resultset on D2009
fixed: AD-0289: MSSQL: Fails to get metainformation, depending on server collation and other related
fixed: AD-0283: MSSQL: Index Names select for MSSQL 2000 does not work (but works with MSSQL 2005)
fixed: AD-0282: MSSQL: fails to apply RecsMax and RecsSkip to SELECT DISTINCT ORDER BY
fixed: ODBC: AV on fetching mkTableFields with Parkway ODBC driver
fixed: ODBC: Parkway Micro Focus ODBC driver fails to handle SQL_C_NUMERIC
fixed: AD-0293: ODBC: AV when CATALOG_NAME_SEPARATOR is empty
fixed: ODBC: AV on fetching using Parkway Micro Focus ODBC driver
fixed: FPC / Linux: AV when a client library is not found
fixed: FPC: fails to reprepare a query
fixed: AD-0308: DataAbstract / Advantage: DAD does not recognise Advantage AUTOINC fields
fixed: AD-0306: AV with SafeMM
fixed: Stan: improved D2010 support in RegExp
fixed: DatS: BLOB fields are reading as NULL's from XML storage
fixed: TADParam.Create has wrong argument type
fixed: ADScript: AV is possible at Destroy
fixed: AD-0301: DApt: DELETE ... WHERE ID=:ID deletes not records
fixed: ADMemTable: Seting TField.DefaultExpression does not work
fixed: Tracer: an exception is created but not raised
fixed: AD-0299: BDE: Migration of D5 TQuery to D2010 TADQuery fails
fixed: AD-0297: ADQuery: does not raise an exception if a transaction is specified without a connection
fixed: AD-0287: fails to call a SP with quoted name and a mixed identifier case
fixed: AD-0291: GUIx: Connection editor: AV at calling the editor at design time
fixed: GUIx: exception in dialog component constructors leads to an AV
fixed: AD-0311: DAbs: AnyDAC DAD fails to compile with the trial AnyDAC version
fixed: ODBC: Parkway Micro Focus ODBC driver fails to handle SQL_C_NUMERIC
fixed: AD-0296: PgSQL: "Cannot parse object name" is raised on a query with sub-queries
fixed: ODBC: AV on fetching using Parkway Micro Focus ODBC driver
fixed: AD-0295: MSSQL: Wrong TEXT value fetched from a resultset on D2009
fixed: AD-0294: ASA: AnyDAC fails to connect to ASA v 11
fixed: AD-0293: ODBC: AV when CATALOG_NAME_SEPARATOR is empty
fixed: FPC / Linux: AV when a client library is not found
fixed: FPC: fails to reprepare a query
fixed: D7: Internal error: E5916 on ADConnection.Connected := True
fixed: AD-0291: Connection editor: AV at calling the editor at design time
fixed: AD-0283: Index Names select for MSSQL 2000 does not work (but works with MSSQL 2005)
fixed: fails to compile with undefined AnyDAC_MONITOR
fixed: TADDataSet: assertion is failed if to call Cancel from BeforePost
fixed: TADDataSet: GetNextPacket returns 0, while there were records fetched
fixed: AD-0290: TADDataSet: FetchAll does not refresh the DB-controls
fixed: AD-0289: MSSQL: Fails to get metainformation, depending on server collation and other related
fixed: AD-0288: IB: Setting IBAdvanced=set_db_readonly=0 does not work
fixed: AD-0287: fails to call a SP with quoted name and a mixed identifier case
fixed: exception in dialog component constructors leads to an AV
fixed: AD-0286: Fails to install on D2010 Prof
fixed: AD-0285: Post/Next statement leads to an infinite loop
fixed: AD-0282: MSSQL: fails to apply RecsMax and RecsSkip to SELECT DISTINCT ORDER BY

New in the “Fall 2009” Release, Version 2.0.13 (Build .1041)

(Status: September 10, 2009)

added: D2010 support
added: PgSQL: support for array data type
added: AD-0278: Expressions: Support for F* and T* as False and True names
added: AD-0271: PgSQL: Add support for UUID data type
added: PgSQL: basic support for array data type (WIP)
added: AD-0264: FB: Add automatic support for auto-generated columns
added: AD-0263: FB: Add support for BOOLEAN domain columns
added: AD-0206: FB: Add FB 2.5 features, including SQLState, isc_dpb_utf8_filename, fb_cancel_operation,SQL_NULL, new keywords and password changing
added: AD-0258: Add XML data type support
added: AD-0255: Add time interval data type support
added: TADTable: Add GetCustomWhere and GetCustomOrderBy
added: AD-0248: Phys: Add ability to specify current catalog / schema for connection
added: AD-0023: Phys: Add LIMIT escape sequence and TADFetchOptions.RowsSkip option
added: AD-0177: Provide origin table name as part of the TField.Origin property value
added: ADO UDL Importer: Add GetRDBMSKind public method
added: ADO UDL Importer: Add MapDataTypes property, allowing to disable data type mapping
added: AD-0237: Implement ActiveStoredUsage inheritance
added: Help: multiple topics added and updated
changed: PgSQL: updated, improved, fixed support for basic data types
changed: Help: updated few topics
changed: AD-0008: Move all SQL generation to IADPhysCommandGenerator
changed: Phys: unified many driver SQL generator code parts
changed: Phys: unified many driver code parts and moved to the TADPhysCommand base class
changed: TADDataSet: AssignField call is replaced with AssignFieldValue
changed: TADDataSet: few methods moved from private to protected section for better compatibility with BDE
changed: Northwind.Products.Discontinued made BOOLEAN in some of DB's
changed: Oracle: improved trace output (added read attribute values)
changed: Oracle: reduced number of ROW_COUNT readings
changed: improved many error messages
changed: ADQA: many tests are updated to the current product state
changed: corrected alignment for CLI units
changed: EADPhysArrayExecuteError renamed to EADDBArrayExecuteError and moved to uADStanError
changed: removed SOUNDEX and DIFFERENCE escape and expression functions
fixed: AD-0262: cxGrid: Inserting a new record using cxGrid is slow
fixed: AD-0273: Single row Execute call does not fire OnError with EADPhysArrayExecuteError
ffixed: AD-0261: AV on Delphi exiting, if to install custom components using AnyDAC
ixed: AD-0281: TADTable: does not automatically fill detail fields from a master dataset
fixed: AD-0280: Oracle: AV on opening "select cursor(select systimestamp from dual) as cur from dual"
fixed: AD-0279: TADAdaptedDataSet: locks immediately in cached updates mode and deferred locking
fixed: AD-0277: MSSQL: Fails to get PK fields on a server with Latin1_General_BIN default instance collation
fixed: DApt: "Cannot perform action without SelectCommand" if the Lock command has failed and DBMS invalidates all commands in TX after that (PgSQL)
fixed: TADQuery: AV is possible is uADDaptManager is not linked
fixed: TADDataSet: AV on closing when "bad" TField.DefaultExpression and 2 assigned TADTransaction's
fixed: DatS: incorrect "fixed length mismatch" error messagefixed: Help: few mistyped property names
fixed: ADMonitor: cannot handle more than one client. May hang at exiting.
fixed: reduced CPU utilization at idling
fixed: AD-0269: AV with MSSQL if refresh called after network disconnect
fixed: AD-0268: ADQuery: may hangup in async mode
fixed: AD-0267: "Connection is not defined for [ADQuery1]" if binded by bbObject to a connection with ConnectionName specified
fixed: AD-0266: DatS: Incorrect "Column [%s] value must be not null" for ReadOnly columns
fixed: AD-0226: TADMemTable: make it more light wheight
fixed: AD-0260: Stan: AV is possible in the timer pool
fixed: FPC: ftWideMemo was not supported on FPC
fixed: AD-0261: AV on Delphi exiting, if to install custom components using AnyDAC
fixed: TADDataSet: delayed scrolling is enabled, even when it should not
fixed: AD-0257: Phys: Incorrect error message, when base driver for a virtual driver is not registered
fixed: Async: possible AV if some service is not linked to app
fixed: AD-0254: TADConnection: ExecSQL / ExecSQLScale may raise "[AnyDAC][Phys][SQLite]-310"
fixed: AD-0236: Moni: Improve control of tracing on/off
fixed: "automatic connection recovery" does not fire OnLosted when died connection is discovered
fixed: AD-0249: CmdPreproc: Recognizes SELECT INTO as skSelect, while it is skInsert
fixed: AD-0244: Partial search works incorrectly
fixed: D2009: variable oMech in uADDatSManager raises a warning
fixed: AD-0240: Failed to build project if AnyDAC_NOLOCALE_DATA is defined
fixed: ConnEdit: the Help button does not work for virtual drivers
fixed: AD-0239: QEdit: "Capability is not supported" on editing a query with escape functions
fixed: ASA: if connecting is failed, then incorrect exception will be raised
fixed: AD-0256: Oracle: "Name [...] is not a callable PL/SQL object (NOE130/SP)" with packed stored proc
fixed: AD-0212: Oracle: "Cannot initialize OCI environment" after 30 sec timeout
fixed: AD-0242: Oracle: "ORA-01036: illegal variable name/number" on parameter names longer than 30 chars
fixed: AD-0246: MySQL: "Table 'test._time' doesen't exist" on SELECT FROM_TIME FROM Tab
fixed: MySQL: the "Commands out of sync" error is possible in some cases
fixed: AD-0265: PgSQL: DataSnap server fails to post updates
fixed: AD-0270: PgSQL: AnyDac with Postgres getting a "data length mismatch" on accessing REAL fields
fixed: AD-0259: FB: TADUpdateSQL.InsertSQL with RETURNING does not refresh auto gen values
fixed: AD-0250: FB: "ADPhysManager shutdown timeout" is possible after TADQuery.Append call
fixed: AD-0276: SQLite: "Updated command updated [0] instead of [1] record" on batch update SQL's
fixed: AD-0275: SQLite: "Index out of bounds" at execution of parameterized batch SQL command
fixed: AD-0241: SQLite: "No such table" / SQLITE_SCHEMA
fixed: AD-0238: SQLite: Fails to execute or open PRAGMA command
fixed: TADCustomManager.GetBaseDriverID does not resolve virtual driver id to a top level id

New in the “Summer 2009” Release, Version 2.0.11 (Build .895)

(Status: May 29, 2009)

added: AD-0019: FPC: Linux support (see AnyDAC\FPC\readme.txt for details)
added: AD-0216: SQLite: An expression type may be specified in SELECT list like a 'count(*) as "cnt::int"'
added: AD-0195: SQLite: finished with ADQA
added: SQLite: support for savepoints
added: MySQL: object names support in error messages
added: Oracle, MSSQL, ASA, MSAccess, DB2, PostgreSQL: AD-0173: Support for binary numeric binding
added: AD-0200: C++Builder: CB 2007 and 2009 support
added: Demo: expression evaluating engine demo in folder Samples\Stan Layer\ExprEval
added: AD-0207: TADDataSet: UpdateConstraints method, actualizing constraints, changed after dataset opening
added: TADDataFormat: RoundToScale property, controlling time data types rounding
added: TADMapRules: Add/Remove methods to simplify map rules management
added: ConDefs: IADStanConnectionDef.MetaDefSchema, MetaDefCatalog properties
added: ADRandomNumber function allowing to generate BCD's with arbitrary precision and scale
added: different parameter markers support for ParamByName and ParamByNumber
added: TADOUDLImporter: OnBeforeWriteOptions event
added: AD-0201: TADOUDLImporter: support for the MSDASQL
changed: AD-0152: Pool: the connection pooling is reimplemented to avoid hang-ups and other issues
changed: Phys: optimized and unified the internal parameter and column management across all the drivers
changed: Phys: unified class names for all the driver classes
changed: AD-0158: Phys: Phys manager thread and connection pool threads replaced by tasks, running by a single thread. And some other threading related changes.
changed: Phys: improved trace output and monitor integration for transaction objects
changed: Phys: cleanup and optimization
changed: DApt: removed server side SELECT items comparision with client values at arLock due to multiple potential rounding errors
changed: ConDefs: major implementation cleanup
changed: Async: added Launched method, plus cleanup and optimization
changed: GUIx: removed TADGUIxFormsListView control, uADGUIxFormsUtil unit, few other changes
changed: GUIx: cleanup of Async dialog API
changed: Oracle: DATE type mapped to ftDateTime (was ftTimeStamp)
changed: Oracle: PREFETCH_ROWS is set to ActualRowsetSize
changed: Oracle: EOCISystemException replaced by EOCINativeException
changed: Oracle: improved trace output for the variables
changed: Oracle: specific demos moved to Samples\DBMS Specific\Oracle
changed: Oracle: ADQA packages are joined into single package
changed: Oracle: conndef importers does not need to map dtDateTimeStamp to dtDateTime anymore
changed: IB: improved trace output
changed: PgSQL: improved support for :param::type
changed: PgSQL: improved support for VendorHome, VendorLib
changed: ODBC: code refactoring and cleanup
changed: TADConnection: AD-0222: Code virtualized to allow the handling of the temporary Connections within a inherited class
changed: TADConnection: optimized TADCustomConnection.ExecSQL and ExecSQLScalar
changed: TADConnection: ValidateName is renamed to DoValidateName and made virtual
changed: TADDataSet: improved protection against running an action, while other is in a progress
changed: improved GetLastAutoGenValue support
changed: Help: improved few topics and added RoundToScale description
changed: ADSpeed: added IB/FB support for test data generator
changed: Tools: default compiler for all tools now is D2009
changed: ADQA: reimplemented connection pool tests
changed: ADQA: updated, fixed, added tests
changed: Demos: Northwind.Products.Discontinued made BOOLEAN in some of DB's
fixed: AD-0219: Oracle: fetch performance degradation on the slow networks
fixed: Oracle: TIMESTAMP support was broken
fixed: Oracle: incorrect list of values for the CharacterSet parameter
fixed: AD-0217: Oracle: AV on DROP TABLE
fixed: Oracle: failed to execute "explain plan" for parameterized SELECT
fixed: IB: "Attempt to reopen an open cursor" onsecond call for SELECT FOR UPDATE statement
fixed: IB: fails to perform {fn CONVERT(..., DATETIME)}
fixed: IB: cannot recognize ekObjNotExists error in some situations
fixed: IB: fails to recognize "table/view does not exists" error on FB 1.5
fixed: PGSQL: incidential call to Win32 API
fixed: PGSQL: TADPhysPgTransaction is in a "dead" state after error in transaction. Application must explicitly Commit / Rollback this transaction.
fixed: AD-0209: PGSQL: Fails to process '::'
fixed: PGSQL: fails to encode / decode some BCD's
fixed: AD-0138: PGSQL: finished with ADQA, multiple fixes and optimizations done
fixed: AD-0030: MSSQL, MSAccess, DB2, ASA: Fetch all and close cursors before Commit/Rollback/StartTransaction
fixed: MSSQL: failed to fetch from systypes with "number out of presion" exception
fixed: MySQL: fails to cancel a running query on v 5.x
fixed: MySQL: BIT support was broken. Now it is mapped to ftBytes.
fixed: MySQL: BOOL support was broken. Now a TINYINT(1) (=BOOL) is mapped to ftBoolean.
fixed: MySQL: BINARY support was portionally broken. Now a binary-string type SELECT item is mapped to ftVarBytes.
fixed: SQLite: published load extensions API
fixed: SQLite: BindNyNumber was broken
fixed: SQLite: transaction begin / end checking was broken
fixed: SQLite: multiple meta-data issues
fixed: SQLite: multiple resultsets support may fail
fixed: AD-0225: ASA: The v 7 and 8 support is broken
fixed: MSAcc: {fn CONVERT} was broken
fixed: AD-0224: ODBC: "Invalid cursor position" at fetching BLOB's from Informix DB
fixed: ODBC: when TADPhysXXXXDriverLink.ODBCDriver is specified, then driver does not use ODBCAdvanced default value
fixed: DB2: few minor issues
fixed: TADDataSet: impossible to post changes in OnBeforeClose
fixed: AD-0211: TADDataSet: Setting ConstraintsEnabled to False does not disable contraints checking
fixed: AD-0205: TADDataSet: fails to assign date string constant to ftTimeStamp field
fixed: AD-0203: TADDataSet: CloneCursor + persistent fkInternalCalc fields fails
fixed: TADDataSet: "Out of bounds" if update FieldDefs with persistent fields and fkInternalCalc
fixed: TADDataSet: SetData fails to import dataset with fkInternalCalc fields
fixed: TADDataSet: Prepare call on detail dataset may fail
fixed: TADScript: AV is possible in some case
fixed: AD-0204: TADScript: ADManager timeout on an application termination
fixed: TADConnection: a password may be removed incorrectly from conn def params
fixed: TADConnection: ExecSQLScalar gives AV on an erroneous SQL command
fixed: TADConnection: memory leak after call to Open(...) method
fixed: TADConnection: ValidateName typo inside
fixed: AD-0228: TADTransaction: fails to start TX after reconnecting
fixed: AD-0208: TADTransaction: AV is possible on destruction
fixed: AD-0213: Fetching: RecsMax / Mode = fmExactRecsMax fetches more records, than specified
fixed: AD-0227: Metadata: most of the drivers do not return ClientVersion / ServerVersion
fixed: AD-0210: UpdateSQL: Mixing macros and parameters in update SQL command text kills parameters
fixed: AD-0218: Update of a fresh inserted Record fails / DApt-400 Error
removed: Basic, Standard, Prof and Enterprise editions. Now only Trial and Full are supported.
fixed: Samples: few D5-D7 incompatibilities
fixed: AD-0215: Install AnyDAC Packages does fails to finish properly (on D2007)
fixed: QBuilder: ASSERT on line 846 if to build cartesian join
fixed: ADMonitor: D2009 incompatibility
fixed: AD-0221: Expression: Comparision of boolean column with True / False always evaluating to False
fixed: Expression: to_date('96-08-29', 'yy-mm-dd') raises "96-08-29 is not a valid date" exception
fixed: AD-0220: DatS: serializing a DatS table to XML gives a mem leak
fixed: DatS: AV is possible in Find method
fixed: parameter value index checking misses the ArraySize = 0 and AIndex <= 0
fixed: Moni: Tracer does not flush all data on timeout
fixed: Demos: multiple issues in demo projects
fixed: Demos: incorrect path in project group
fixed: BCB: C++Builder 2006 incompatibility
fixed: Trial: AD-0229: AnyDAC Trial version fails to install on Delphi Professional

New in the “Spring 2009” Release, Version 2.0.9 (Build .737)

(Status: February 29, 2009)

added: PGSQL: Final version of the driver
added: SQLite: Final version of the driver
added: MySQL: support for ServerOutput
added: Demo: Oracle PL/SQL table Samples\Comp Layer\TADStoredProc\Oracl_PLSQLTable
added: TADDataSet: new options coAppend, coEdit for the CopyDataSet method
added: TADConnection: new ConnectionMetaDataIntf property
added: TADConnection: new ExecSQLScalar method
added: TADConnection: new GetInfoReport method, to obtain info about environment
added: Demo: Info reporting Samples\Comp Layer\TADConnection\InfoReport
added: ADDataMove: new property TextDataDef.StrsEmpty2Null
added: ADDataMove: a conversion expression may be specified for a source field
added: AD-0180: Login Dialog: add ability to translate the option captions
added: ADScript: new SET IGNORE[error] command
changed: TADDataSet: optimized bookmarks comparision to improve the performance of a dbGrid with many rows
changed: AD-0179: RefreshRecord should delete client record if corresponding one in DB is deleted. Also added UpdateOptions.RefreshDelete option controlling that.
changed: IB/FB: AD-0105: improved and finished Unicode support
changed: extended connection reporting info
changed: improved and unified FetchOptions.RecsMax support for most of the drivers
changed: improved stability of the TADThread
changed: Help: improved many topics
changed: utilities are Unicode enabled
changed: Oracle: {INTO} escape sequence is expanded into INTO keyword
changed: SQLite: TSQLiteCollation splitted into TSQLiteCollation and TSQLiteCollationCompareStringW
changed: implemented CliObj for all driver objects
changed: finalizing improving CopyDataSet, CopyRecord
fixed: MySQL: "int unsigned auto_increment" column is not recognized as a TADAutoIncField
fixed: MySQL: fails to assign a MinInt value to a ftInteger parameter
fixed: MySQL: returns incorrect character field length when UTF8 client character set
fixed: MySQL: outputs user password into a driver trace
fixed: MySQL: stored procedure support was broken
fixed: MySQL: TIBYBLOB, TINYTEXT support was broken
fixed: MSSQL: AD-0146: fails to retrieve metadata with osMy scope from 2005 or higher server
fixed: MSSQL: raises "class is not registered" hidden exception, when SQLDMO is not installed
fixed: Oracle: returns incorrect temporary tables metadata
fixed: Oracle: raises "file not found" at login, if tnsnames.ora does not exist
fixed: Oracle: CLOB / BLOB updates posting issue
fixed: Oracle: does not support PL/SQL table of zero length
fixed: possible incorrect transaction handling, when the same transaction object is a default and an update transaction
fixed: IB: does not return correct field origin
fixed: MSAccess: a Varchar result set column may be defined as a Memo one
fixed: TADDataSet: fails to serialize dtTime
fixed: TADDataSet: losts a new record, if to set a filter in dsInsert mode
fixed: TADDataSet: ServerDeleteAll erroneously requires dataset to be opened
fixed: TADDataSet: CopyDataSet was broken
fixed: TADDataSet: FetchAll may lead to unlimited recursion for cloned datasets
fixed: AD-0181: AV at inserting new record into empty dataset when locking is on
fixed: TADDataSet.CopyRecord is writing to read-only fields
fixed: DataAbstract: AnyDAC DAD may raise a "Parameter data type is changed" exception
fixed: DataSnap: server may hang-up on exiting, if before was a database error
fixed: DataSnap: TDataSetProvider fails to use multiple result sets of the single command
fixed: TADScript: AV at executing a SQL command of 4092 byte length or greater
fixed: dynamically added connection definition does not inherit the tracing and monitor parameters in the ADSettings section
fixed: $(TEMP)\trace$(NEXT).txt fails to return next file name
fixed: {IIF} escape sequence fails, if any of values contains ')'
fixed: dtGUID to dtWideString / dtAnsiString value coversion was broken
fixed: installer fails to detect D5-D7 Professional SKU
fixed: AnyDAC fails to compile on Korean Windows
fixed: D2009 does not register field classes introduced in D2009
fixed: fails to open the demos in IDE, as some of the GUIx components are not registered
fixed: few ADExplorer issues
fixed: PgSQL, MySQL, IB: unified TypeName format (removed length, precision, scale)
fixed: PgSQL: bind by number, output parameter, CliObj, TID handling issues
fixed: AD-0193: Demo: CachedUpdates demo fails on few DBMS's
fixed: PgSQL: issues are demo database installation
fixed: AD-0192: Blobs demo does not work
fixed: AD-0191: GUIx: LoginDialog/Main demo does not work
fixed: AD-0190: MSSQL: "Connection is busy" if to open few meta-data cursors
fixed: AD-0189: MemTab: Appending record to a DS with nested dataset raised AV
fixed: AD-0188: ADExplorer does not show the MySQL database names
fixed: AD-0187: Second call to the CloneDataset for the same DS fails
fixed: AD-0186: CmdGen: Update SQL Editor generates incorrect FetchRowSQL
fixed: AD-0185: TADDataSet: After failed posting of an insert to DB, record position will be changed to bottom
fixed: AD-0184: IB: [AnyDAC][DApt]-400 on posting new record using INSERT ... RETURNING

New in Version 2.0.7 (Build .551)

(Status: November 28, 2008)

added: PostgreSQL driver (beta-version) (See Wiki for setup details).
added: SQLite driver (beta-version) (See Wiki for setup details).
added: Delphi 2009 complete support (See Wiki for Unicode usage details).
added: MySQL: support for embedded MySQL server - LIBMYSQLD (See Wiki for setup details).
added: MSAccess: added support for Access 2007
added: MSSQL: added basic support for MSSQL 2008
added: Help: many new topic described and updated old ones, adjusted general Help structure
added: Support for Delphi Professional SKU
added: few new design-time editors, improoved old ones. Also design time setup dialog to control metadata to return.
added: UnifyParamNames property, controlling striping of '@' from MSSQL SP param names (False by default)
added: MonitorBy=FlatFile shows message on application exit with list of produced trace files
added: at design time TADMemTable with ResourceOptions.Persistent=True and empty FileName stores content into DFM file
added: TADDataSet: RefreshUnknownRecord method allowing to insert into internal data storage not fetched record and refresh it
added: TADDataSet: MasterScrollDelay property allowing to delay refresh of detail dataset on master scroll event
added: TADAutoIncField.GeneratorName property
added: method TADCustomConnection.ReleaseClients
changed: MSSQL: improved MSSQL cursor type control. As result, the fetch speed is raised few times. Still if automatically selected cursor is not OK, you can control it through FetchOptions.CursorKind.
changed: MSSQL: does not work properly with EOL = #13. AnyDAC now adjust EOL to #13#10
changed: TADDataSet.Execute now is virtual
changed: TADMemTable.Open may be used instead of CreateDataSet
fixed: TADMemTable does not use CachedUpdates property
fixed: few nested dataset issues
fixed: few cloned dataset issues
fixed: few dataset streaming issues
fixed: if required field is not included into persistent field list, then AnyDAC raises error, that field value is required
fixed: MSSQL: only first PRINT statement result is returned
fixed: MSSQL: RowsAffected may be incorrect in some cases
fixed: MSSQL: ADDataMove cannot insert identity value into BIGINT IDENTITY field
fixed: MSSQL: possible "WHERE must be not empty" on generating INSERT command
fixed: ASA: fails to fetch rowset with BLOB in the middle
fixed: TADTextWriter fails to write UTF16 text
fixed: explicit setting TADxxxOptions option value to its default value, does not override inherited value
fixed: ResourceOptions.Persistent and Backup was always overwritten by design time editors
fixed: UpdateOptions.UpdateTableName is ignored
fixed: Oracle: password is put into trace
fixed: Oracle: CurrentSchema was not updated
fixed: IB: AV on getting meta info kind = mkPackages
fixed: IB: if Unidirectional = True, then "cannot perform this operation on unidir dataset" after Next on last dataset record
fixed: IB: "assertion failed" at Ping call
fixed: MSAccess: does not allow insert value into autoincrement column
fixed: DB2: UK violation exception is not raised, but put into Messages
fixed: sequences / generator support was broken
fixed: AV possible in TADGUIxFormsAsyncDialog
fixed: asynchronous command execution potential timing issues
fixed: settingup TADStoredProc at design time gives AV
fixed: assignment to the TBCDField.Value truncates value
fixed: AV at parameterized query execution if to use AsFloat and dtBCD -> dtDouble data type mapping
fixed: [AnyDAC][Stan][Def]-250, if to setup driver link
fixed: "object xxx is not found" if to specify custom parameter in TADUpdateSQL.XxxxSQL
fixed: fails to edit SELECT columns with aliases
fixed: hangup at application exit after recovering of losted connection
fixed: hangup at Commit/Rollback after recovering of losted connection
fixed: DataSnap: fails to transfer AnsiString parameters
fixed: AV at recovering of losted connection
fixed: ADExplorer fails to work on clear workstation
removed: TADUpdateOptions.CacheUpdateCommands is removed

New in Version 2.0.5 (Build .365)

(Status: August 31, 2008)

added: AD-0017, 0066: Delphi 2009 support and complete Unicode support
added: support for WITH ... SELECT
added: IADPhysConnection.CurrentCatalog & CurrentSchema read-only props
added: MSSQL, ASA: support for {fn CATALOG()} escape sequence
added: method TADCustomConnection.Open(AConnectionString)
added: property TADCustomConnection.Messages
added: MySQL: support for command execution abortion
added: AD-0088: FlatFile parameter MonitorByFlatFile_Columns
added: AD-0094: trace output for non-EADDBEngineException's
added: Oracle: added CharacterSetName connection definition parameter
added: TADDataMove.TextFileEncoding, LogFileEncoding new properties
added: MonitorByFlatFile_Encoding new parameter
added: AD-0085: MSSQL 2005: support for password changing, XML and UDT data types, snapshot transaction isolation
added: AD-0110: snapshot transaction isolation level
added: TADScript: SET ENCODING command
added: TADAutoIncField.IdentityInsert property, TADDataMoveOptions.poIdentityInsert option
added: MySQL: support for FetchOptions.RecsMax & SELECT
added: AD-0087: FetchOptions.CursorKind property
added: support for ReadOnly transactions for all ODBC based drivers
changed: unified variables naming for trace output
changed: few TADParam / TADParams minor improvements
changed: MonitorBy=FlatFile|Custom will not output at design time
changed: Oracle: dumping V$NLS_PARAMETERS now is off by default
changed: improved support for Sybase ASE / Informix DBMS's
changed: cleanup and simplification of Query Builder
changed: AD-0082: improved most of dataset error messages
changed: improved cloned dataset support
changed: improved Unidirectional=True handling
changed: AD-0081: UpdateOptions.UseProviderFlags is removed
changed: TADParam.Size < 0 is equivalent to = 0. Variable length data parameter values are checked agains TADParam.Size right at value assignment.
changed: AD-0093: improoved API to get client / server / anydac info
changed: MySQL: Utf8Mapping parameter is removed
changed: Oracle: removed BytesPerChar connection definition parameter
changed: AD-0088: improved and unified FlatFile and Remote output formats
changed: most of expression evaluator functions moved to uADStanExprFuncs unit
changed: TADQuery.DataSource renamed to MasterSource (keeping backward compatibility), MasterFields is published
changed: improoved cursor type control all ODBC based drivers
changed: improoved TADTable design time support
changed: AD-0062: Prepared property move to public
fixed: IB: "value too large for variable" on UTF8 strings and Array DML
fixed: IB: UTF8 support was broken
fixed: Oracle: ORA-00922 if set connection definition parameter SQLTrace=True
fixed: ODBC: cannot connect to MSSQL using ODBC bridge driver
fixed: MSSQL: force direct execution for some of the queries (BACKUP, etc)
fixed: {IF} ... {FI} escape sequences support was broken
fixed: {S} escape sequence support was broken
fixed: single #13 is removed from SQL command, giving syntax error
fixed: wrong processing of '\', if not (piExpandEscapes in Instrs)
fixed: Lock and update commands with UpdateChangedFields=False include non-updatable columns into SQL
fixed: AD-0069: few issues with selecting metadata mkTables
fixed: AD-0080, 0079: rounding issue at dtFmtBCD -> dtDouble mapping
fixed: AD-0001: issue at dtAnsiString -> dtIntXXX mapping
fixed: AD-0003: if set MasterFields before IndexFieldNames, then ADMemTable will be emtied
fixed: application hang ups if an unhandled EADDBEngineException exception was raised
fixed: C++Builder 5 incompatibility in uADPhysODBCBase
fixed: few issues in ADExplorer
fixed: AD-0091: transaction remains active after posting updates with LockMode <> lmNone
fixed: Query Builder does not return SQL text
fixed: AD-0081: setting UpdateOptions.KeyFields does not have effect after Open call
fixed: AD-0094: few tracing regression issues
fixed: AD-0096: Oracle: failed connect to Oracle 11g
fixed: AD-0100: MSSQL: Array DML fails on MSSQL 2005
fixed: AD-0099: ODBC: Fixed char data type support is broken in all ODBC based drivers
fixed: AD-0102: Oracle: fixed Oracle 10g incompatibilities
fixed: ASA: fixed "invalid cursor position" error
fixed: AD-0107: MSSQL: TADQuery.Edit / Post fires triggers, but it fails
fixed: AD-0108: MSSQL: money type is mapped to BCD instead of Currency
fixed: AD-0109: AV at assigning of empty string to TADParam.AsWideString
fixed: AD-0111: Client autoincrementing does not work for dataset in CachedUpdated mode with default fields
fixed: AD-0103: TADDataMove fails to assign value to auto-increment fields
fixed: AD-0112: Too large memory consumption on fetching large datasets
fixed: AD-0042: Inserting into detail TADQuery, does not fill detail fields
fixed: AD-0067: TADQuery.MasterFields is cleared after setting DataSource
fixed: TBytesField can return garbage after actual value
fixed: FetchOptions editor frame issues
fixed: AD-0009: Oracle: automatic connection recovery fails in 2 additional cases
fixed: AD-0114: AV / Invalid pointer operation in D5 applications
fixed: ERegistryException at Delphi IDE startup
fixed: AD-0059: few TADDataSet asynchronous mode issues

New in Version 2.0.3 (Build .295)

(Status: May 30, 2008)

added: ADO UDL importer parameter shortcuts support for ASA
added: TADDataSet.CopyDataSet method
added: TADCustomTransaction.NestingLevel property
added: check that number of parameters remains the same after Prepare
added: Context Database Designer adapter added to the 3d party
added: Fast Report 3 integration added to the 3d party
added: IB/FB: added SQL dialect 1 support
added: VendorHome, VendorLib, ODBCDriver, ODBCAdvanced driver link properties added
added: FPC v 2.2.1 support
added: {s ...} escape sequence added
added: ADExecutor will execute command from standard input, if no scripts is specified
changed: AnyDAC does not anymore depend on Indy.
Indy monitoring replaced by Remote one, use MonitorBy=Remote.
changed: in uADCompDataMove.pas all AsciiXXX renamed to TextXXX
changed: reorgonized TADTxOptions - added xoFinishRetaining to StopOptions,
StopAction renamed to DisconnectAction, DisconnectAction controls
only what will happen on connection closing
changed: AutoCommit and TransIsolation connection definition parameters are removed
Use TxOptions properties instead.
changed: optimized tracing / monitoring code. Now application
will run fast with {$DEFINE AnyDAC_Monitor}.
changed: lock mode lmRely renamed into lmNone
changed: added name reporting to few error messages
changed: optimized internal query text handling
changed: ODBC: optimized rows fetching for 5%
changed: Oracle: optimized cursor opening
changed: TADDatSRow.ValueXXX properties are now writable.
Value[] is the default property.
fixed: fails to convert dtBlob to dtAnsiString
fixed: memory leak if TADQuery.Post -> exception -> TADQuery.Free (AD-71)
fixed: ADQuery does not fetch detail records if fiDetails is in FetchOptions.Cache
and FetchOptions.RecordCountMode <> cmVisible (AD-72)
fixed: IB: few array dml issues on FB & UTF8
fixed: Oracle: "no data found" on REF CURSOR
fixed: Oracle: ORA-01453 on repeating Edit/Post more than 2 times
fixed: Oracle: ORA-01722 possible, if to map dtDouble to dtBCD on FLOAT(126) fields (AD-74)
fixed: MSSQL: few array dml issues (AD-78, AD-65, etc)
fixed: Oracle: possible ORA-24508 at fetching NVARCHAR(15)
fixed: Oracle: erroneously recognizes :new. / :old. as parameters
fixed: ADScript: AV at disconnected executing
fixed: ADScript: COPY FROM FILE builds incorrect CSV file name
fixed: ADScript: AV in ADDataMove in "silent" mode
fixed: Prepare makes parameter references invalid (AD-63)
fixed: TDataSet.GetCanModify is not overriden (AD-64)
fixed: FastReport adapter does not set parameter values correctly
fixed: command does not use TADTransaction assigned to TADConnection.Transaction
fixed: "dataset must be active" error on DBGridEh connected to inactive dataset
fixed: RecordCountMode=cmTotal on unidirectional dataset may fetch all records
fixed: IB: Array DML has bugs in isc_dsql_batch_execute, so do not use it
fixed: IB: TADParam.Size / Precision / Scale was not used
fixed: IB: incorrectly recognizes "cannot create ..." error as "object does not exist"
fixed: MSSQL: varchar(max) support was broken
fixed: "ADMENU not found" at design time package loading
fixed: FPC v 2.2.1 incompatibility issues
fixed: FPC v 2.2.1 incompatibility issues
fixed: "[RC fatal Error] uADSplash.res(1) Input and output file names are the same"
fixed: ApplyUpdates, Reconcile does not use ResourceOptions.SilentMode
fixed: few issues in remote monitoring
fixed: all dialogs will be now main form centered
fixed: DBERR_NONE is not found on D7
fixed: dataset with current index on InternalCalc field, losts position after post
fixed: few issues in TADTable
fixed: few issues in ADScript
fixed: MSAccess: "Cannot parse name" on select * from "c:\db.mdb".MyTable
fixed: TDBX: bridge multiple issues are fixed
fixed: MySQL: Does not support &&
fixed: IB: improoved FB Embedded support
fixed: MSSQL: "Invalid character value for cast specification" on Array DML
fixed: MSSQL: possible wrong bytes in fetched BLOB values
fixed: Oracle: NUMBER is defined as dtDouble, but must be dtFmtBCD
fixed: Connection editor fails to edit active connection
fixed: ODBC: few incompatibility issues (with Informix and Sybase Adaptive servers)

New in Version 2.0.1 (Build .283)

(Status: March 6, 2008)

added: TADQuery.ExecSQL will take parameter values from MasterSource, if specified
added: DBX bridge updated to current DBX4 API, added correct meta data handling
changed: after installation, ADDrivers.ini will be empty
changed: renamed ResourceOptions.MaxBatchSize into ArrayDMLSize
changed: ResourceOptions.AutoConnect, AutoDisconnect, AutoOnline replaced by AutoManage
changed: AutoConnRestore renamed to AutoReconnect and published TADConnection.OnRecover/OnLosted/OnRestored
changed: TADDataSet.Unidirectional moved to FetchOptions.Unidirectional
changed: TADDataSet.UpdateRecordTypes renamed into FilterChanges
changed: now AnyDAC_NOLOCALE_DATA and AnyDAC_NOLOCALE_META are not defined by default
fixed: DBX: MS SQL CE incompatibility issues in DBX Bridge
fixed: DS: AV on insert record with dupe key, then deleting last record in dataset
fixed: DS: After adding new record with dup key, then canceling
addition, dataset position changes incorrectly
fixed: DS: descending sorting using index does not work correctly
fixed: DS: FindKey does not use case-insensitive index
fixed: XML streaming of ftDateTime, ftTimeStamp does not work
fixed: possible incorrect detection of stream format
fixed: Oracle: generation of wrong PL/SQL block for stored procedure call from pre-specified parameters
fixed: Oracle: possible incorrect handling of OCI_NO_DATA
fixed: Oracle: PL/SQL table support were broken
fixed: Sybase ASA: connection parameter Server does not work
fixed: BCB5 incompatibility fixed: ADExplorer does not show data for Sybase SQL Anywhere tables
fixed: IB: OpenOrExecute does not work
fixed: Query Builder does not support quoted column names
fixed: AV in DataSet Editor
fixed: Support for quoted column names was broken

New in Version 2.0.1 (Build .281)

(Status: February 21, 2008)

Initial Release