|
D2010, Firebird 2.5, PostgreSQL array and some other data types, SQL XML data type, SQL time INTERVAL data type, LIMIT escape function and FetchOptions.RowsSkip property, optimization, multiple refactorings and fixes.
------------------------------------------------------------
v 2.0.13.1041 (09.09.09)
+ added: PgSQL: support for array data type
+ added: AD-0278: Expressions: Support for F* and T* as False and True names
/ changed: PgSQL: updated, improved, fixed support for basic data types
/ changed: Help: updated few topics
- fixed: 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 message ------------------------------------------------------------
v 2.0.13.1025 (27.08.09)
+ added: D2010 support
+ added: AD-0271: PgSQL: Add support for UUID data type
+ 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: 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
- fixed: AD-0261: AV on Delphi exiting, if to install custom components using AnyDAC
- fixed: 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 |
