v 2.0.11.895 (25.05.09) 

• 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 <non-existant one>
• 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