v 4.0.5.1605 (24.11.10)

  + added: SQLite: TADSQLiteValidate component
  + added: SQLite: SharedCache connection definition parameter
  + added: ADTable: Open(ATableName) method
  + added: Phys: MetaCurSchema / MetaCurCatalog = '*' avoids implicit inclusion of schema / catalog names into full object name
  + added: mkCatalogs, mkSchemas meta data kinds and GetCatalogNames, GetSchemaNames methods
  + added: base x64 support
  + added: AddOn: EhLib support
  / updated: Help: major cleanup and multiple extensions
  / updated: ADDataSet: major optimization
  / changed: DatS: optimized view building code
  / changed: IB: optimized driver code
  / changed: DatS: improved fetch performance
  / changed: PgSQL: improved fetch performance
  / changed: AddOn: updated SQL Ini File
  / changed: DBX: added AnyDAC_DBX define to control AnyDAC linking to dbExpress
  / changed: multiple extensions and changes to AnyDAC service components
  / changed: SQLite: optimized build defines
  / changed: ADManager: the GetDriverNames method now has AValidate, allowing to check is the DBMS CLI installed and it may be loaded
  - fixed: SQLite: few multi-threading issues in encryption code
  - fixed: SQLite: does not use TFormatOptions.StrsTrim and StrsEmpty2Null
  - fixed: SQLite: "Cannot rollback transaction - SQL statements in progress" on Rollback with active result sets
  - fixed: SQLite: CheckEncryption fails to validate DB. Also, improved reporting.
  - fixed: SQLite: TADSQLiteSecurity.RemovePassword was not working
  - fixed: MSSQL: "The data types varbinary(max) and image are incompatible in the equal to operator"
  - fixed: MSSQL / ASA: "No column was specified for column 1 of 'A'." on a query with RecsMax specified
  - fixed: MSSQL: "invalid object name" on SELECT FROM ::fn_xxxx()
  - fixed: MSSQL: MARS is always enabled for a connection and cannot be disabled
  - fixed: PgSQL: returns incorrect value for TIMESTAMPTZ columns
  - fixed: PgSQL: escape functions CURDATE, CURTIME, NOW does not work
  - fixed: PgSQL: AV when fetching UTF8 string with mapping WideString -> AnsiString
  - fixed: PgSQL: fails to edit query with ONLY keyword
  - fixed: IB/FB: fails to use quoted identifiers
  - fixed: FB/IB/MySQL: possible AV at application exiting, when using embedded engines
  - fixed: Oracle: fails to execute AnyDAC QA scripts
  - fixed: Oracle: a failed execution in autocommit mode leads to an active transaction
  - fixed: DB2: fails to fetch meta data after SET SCHEMA=xxx command
  - fixed: ASA: fails to execute stored proc with inout params in a loop
  - fixed: ADS: memory corruption at metadata retrieval
  - fixed: MSAccess: does not support ` and " as object name quote chars
  - fixed: Informix: exception is not raised on posting update using invalid SQL in TADUpdateSQL
  - fixed: ODBC: improved compatibility with old drivers
  - fixed: ODBC: does not recognise ADS DSN as mkADS
  - fixed: ODBC: fails to execute PostgreSQL parameterized query
  - fixed: Stan: AV is possible on application exiting
  - fixed: Phys: Memo -> String mapping is completely broken
  - fixed: Phys: transaction properties are not updated after reconnection
  - fixed: Phys: MetaDefXxx and MetaCurXxx are not visible in connection editor
  - fixed: Phys: issues with executing COMMIT / ROLLBACK commands directly
  - fixed: Tracing: impossible to set TADMoniXxxClientLink.Tracing to True at design-time
  - fixed: ADDataSet: SaveToStream does not store field captions
  - fixed: ADDataSet: Refresh on indexed detail dataset empties dataset
  - fixed: ADDataSet: BeforeGetRecords / AfterGetRecords does not fire for async queries
  - fixed: ADDataSet: AV is possible on ADConnection destroying
  - fixed: ADDataSet: refresh on detail dataset does not work if master dataset is in editing / inserting state
  - fixed: ADDataSet: after deletion of last fetched record the query position may change to next+1 record
  - fixed: ADDataSet: AV at assigning empty string to TGuidField
  - fixed: ADDataSet: setting UpdateOptions.CheckRequired to False after Open and before Append has no effect
  - fixed: DApt: fails to edit dataset with quoted field names
  - fixed: Query Editor may hang up at design-time
  - fixed: DatS: BeginBatch / EndBatch fails with unidirectional query
  - fixed: GUIx: connection editor fails to store database path
  - fixed: GUIx: few ADUpdateSQL editor issues
  - fixed: GUIx: wrong help link
  - fixed: ADConnection: possible AV at application exiting
  - fixed: AnyDAC fails to install on Delphi XE Professional
  - fixed: memory leak is possible on application exiting
  - fixed: Demo: TADEventAlerter demo was broken
  - fixed: D5: major incompatibility

--
With best regards,
DA-SOFT Technologies Team
http://www.da-soft.com