Additional
Syndicate
Subscribe to our News, Blogs and Updates
 
Polls
If you are the Delphi programmer, how old are you ?
 
AnyDAC for Delphi v 2.0.13.1041 released PDF Print E-mail
Sep 16, 2009

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