AnyDAC for Delphi v 2.0.15.1163 released
Nov 25, 2009
Added PostgreSQL support for the array and composite data types. The TADScript documented and added few demos.

 

------------------------------------------------------------
v 2.0.15.1163 (26.11.09)
  + added: PgSQL: support for array and composite types
  + added: Firebird: supported for trusted authentification
  + added: AD-0315: GUIx: Add exception handling control to the TADGUIxFormsErrorDialog
  + added: MSAccess: support for INSERT INTO .. DEFAULT VALUES
  + added: ADExplorer: added support for connection recovery
  + added: Demo: TADScript demos are added
  + added: Help: TADScript is described
  / 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: TADScript: multiple improvement and code cleanup
  - 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

------------------------------------------------------------
v 2.0.14.1109 (27.10.09)
  + added: SQLite: support for PRAGMA = FOREIGN_KEYS
  + added: DatS: add versioning to the DatS streaming. Added TADResourceOptions.DefaultStoreVersion property.
  + added: TADDataSet: Add Distinct property to TADIndex
  / changed: Phys: now ExtendedMetaData is False by default
  / 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: better diagnostic for "factory is not found" error
  / changed: FR4 addon: added D2010 package files, minor fix
  / changed: [IB|PG]ExtendedMetaData renamed to ExtendedMetaData
  / changed: Tools: now is Unicode
  / changed: added uADStanAsync to script engine
  / changed: Stan: Options implementation is reworked to make it possible to implement profiles, etc. Also, now it is few ten % faster.
  - 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

------------------------------------------------------------
v 2.0.14.1078 (09.09.09)
  - changed: [IB|PG]ExtendedMetaData renamed to ExtendedMetaData
  - changed: now ExtendedMetaData is False by default
  - 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
  / changed: Phys: changed uADPhysXxxMeta to use AnsiQuotedStr
  / changed: ADS: few issues fixed
  + added: TADDataSet: Add Distinct property to TADIndex
  - 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
  / changed: FR4 addon: added D2010 package files, minor fix
  - 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