v 4.0.1.1463 (23.08.10)

Note: The following properties default values were changed:
1) TADMemTable.ResourceOptions.SilentMode is now True
2) TADMemTable.UpdateOptions.CheckRequired is now False
3) TADDataSet.ConstraintsEnabled is now False

  + added: MSSQL: SQL Azure support
  + added: SQLite: strong AES encryption support. Provided in partnership with StreamSec company.
  + added: SQLite: v 3.7.0.1 support
  + added: ASA: v 12 support
  + added: DBMS service components - backup, restore, repair, etc for Firebird, SQLite, MS Access, SQL Anywhere
  + added: ftSingle, ftExtended data types support
  + added: ADMemTable: few APIs for CDS compatibility: LogChanges, Set/GetOptionalParams, etc
  + added: ADDataSet: UpdateOptions.CheckRequired option to control TField.Required
  + added: ADDataSet: OnMasterSetValues event allowing to override detail dataset parameters
  + added: ADConnection: few more Open overload methods
  + added: ADScript: Transaction property
  + added: ADScript: ScriptOptions.RaisePLSQLErrors option
  + added: GUIx: TADGUIxFormsAsyncExecuteDialog.Prompt
  + added: GUIx: open dialog for Database parameter
  + added: DataAbs: AnyDAC DAD added to the installer
  + added: DesignTime: ability to enable / disable AnyDAC IDE menu using AnyDAC_DesignTimeMenu define
  + added: GetBaseDriverID and GetRDBMSKind methods
  + added: Phys: skMerge command kind for MERGE / INSERT OR UPDATE commands
  + added: RAD Studio XE support
  / changed: SQLite: extended session information
  / changed: Oracle: optimized driver performance by removing Describe call
  / changed: Oracle: optimized the mkIndexes performance
  / changed: ADDataSet & ADMemTable: major optimization
  / changed: Informix: major optimization
  / changed: TDBX: improved Delphi 2010 support
  / changed: SQLiteIniFile: added compression support to the addon
  / changed: ADScript: improved compatibility with IBScript, added SET SQL DIALECT, CLIENTLIB, etc commands and support for CREATE DATABASE
  / changed: Help: extended and reorganized
  - fixed: SQLite: fails to return "file not found" error message
  - fixed: FB/IB: may fail to assign a string value to a number or date typed parameter
  - fixed: FB: Array DML and INSERT OR UPDATE may fail with "too many contexts"
  - fixed: FB: Array DML & UTF8 column & no client charset fails to insert data into the column
  - fixed: Oracle: exclusion of fiBlob from FetchOptions.Items leads to AV
  - fixed: Oracle: out CLOB parameter reading may fail with error
  - fixed: Oracle: fails to connect using Oracle 10g easy connection string
  - fixed: AD-0360: Oracle: does not distinguish 32 and 64 bit Oracle Homes
  - fixed: PgSQL: AV with high-precision numeric values
  - fixed: Informix: does not raise an exception for a constraint violation
  - fixed: MSSQL: {LIMIT} escape sequence may lead to syntax error when a query has ORDER BY, UNION, DISTINCT, etc
  - fixed: MSSQL: SQL_NO_DATA error on UPDATE with ftWideMemo param and not records found
  - fixed: MSSQL: "ADPhysmanager shutdown timeout" after pinging a broken connection  - fixed: MySQL: does not return precision for integer typed columns
  - fixed: TDBX: "cannot parse object name" exception
  - fixed: TDBX: 2 memory leaks
  - fixed: TDBX: fails to fetch Unicode Memo fields
  - fixed: ADConnection: AV with ADConnection.ExecSQL & connection recovery
  - fixed: ADConnection: changing MonitorBy has no effect
  - fixed: Phys: memory leak is possible if connecting is failed
  - fixed: Phys: changing IADPhysConnection.Tracing has no effect
  - fixed: ADDataSet: SetKey / GotoKey may fail to locate a record on a sorted dataset
  - fixed: ADDataSet: ftBCD calculated field returns invalid value
  - fixed: ADDataSet: Stream format incompatibility between 2.0.13 and 3.0.1
  - fixed: ADDataSet: fails to serialize WideString values
  - fixed: ADDataSet: exception in AppendRecord / InsertRecord leads to memory leak
  - fixed: ADDataSet / Stan: Exception.Errors are not stored with row
  - fixed: ADDataSet: TADIndex.Distinct may fail to remove duplicated records
  - fixed: ADDataSet: AV on ApplyUpdates, when all record are deleted and OnUpdateRecord is assigned
  - fixed: ADDataSet: AV is possible after record deletion with a TDBGrid in multy row select mode
  - fixed: ADDataSet: adding fields at design-time leads to Indexes deletion
  - fixed: ADMemTable: CloneCursor & OnFilterRecord lead to AV
  - fixed: ADMemTable: FieldDefs and IndexDefs are not stored in DFM. For that StoreDefs must be set to True by hands.  - fixed: TADTable: "Unique constraint violated" on unique index creation with NULL values in indexed columns
  - fixed: GUIx: fails to call TADGUIxFormsLoginDialog.Execute directly
  - fixed: DataSnap: Param.ParamType = ptUnknown made compatible with DataSnap
  - fixed: FR: fails to produce a report with the duplicate parameter names in a query