v 2.0.9.737 (01.03.09) 

• added: PGSQL: Final version of the driver
• added: SQLite: Final version of the driver
• added: MySQL: support for ServerOutput
• added: Demo: Oracle PL/SQL table Samples\Comp Layer\TADStoredProc\Oracl_PLSQLTable
• added: TADDataSet: new options coAppend, coEdit for the CopyDataSet method
• added: TADConnection: new ConnectionMetaDataIntf property
• added: TADConnection: new ExecSQLScalar method
• added: TADConnection: new GetInfoReport method, to obtain info about environment
• added: Demo: Info reporting Samples\Comp Layer\TADConnection\InfoReport
• added: ADDataMove: new property TextDataDef.StrsEmpty2Null
• added: ADDataMove: a conversion expression may be specified for a source field
• added: AD-0180: Login Dialog: add ability to translate the option captions
• added: ADScript: new SET IGNORE[error] command
• changed: TADDataSet: optimized bookmarks comparision to improve the performance of a dbGrid with many rows
• changed: AD-0179: RefreshRecord should delete client record if corresponding one in DB is deleted. Also added UpdateOptions.RefreshDelete option controlling that.
• changed: IB/FB: AD-0105: improved and finished Unicode support
• changed: extended connection reporting info
• changed: improved and unified FetchOptions.RecsMax support for most of the drivers
• changed: improved stability of the TADThread
• changed: Help: improved many topics
• changed: utilities are Unicode enabled
• changed: Oracle: {INTO} escape sequence is expanded into INTO keyword
• changed: SQLite: TSQLiteCollation splitted into TSQLiteCollation and TSQLiteCollationCompareStringW
• changed: implemented CliObj for all driver objects
• changed: finalizing improving CopyDataSet, CopyRecord
• fixed: MySQL: "int unsigned auto_increment" column is not recognized as a TADAutoIncField
• fixed: MySQL: fails to assign a MinInt value to a ftInteger parameter
• fixed: MySQL: returns incorrect character field length when UTF8 client character set
• fixed: MySQL: outputs user password into a driver trace
• fixed: MySQL: stored procedure support was broken
• fixed: MySQL: TIBYBLOB, TINYTEXT support was broken
• fixed: MSSQL: AD-0146: fails to retrieve metadata with osMy scope from 2005 or higher server
• fixed: MSSQL: raises "class is not registered" hidden exception, when SQLDMO is not installed
• fixed: Oracle: returns incorrect temporary tables metadata
• fixed: Oracle: raises "file not found" at login, if tnsnames.ora does not exist
• fixed: Oracle: CLOB / BLOB updates posting issue
• fixed: Oracle: does not support PL/SQL table of zero length
• fixed: possible incorrect transaction handling, when the same transaction object is a default and an update transaction
• fixed: IB: does not return correct field origin
• fixed: MSAccess: a Varchar result set column may be defined as a Memo one
• fixed: TADDataSet: fails to serialize dtTime
• fixed: TADDataSet: losts a new record, if to set a filter in dsInsert mode
• fixed: TADDataSet: ServerDeleteAll erroneously requires dataset to be opened
• fixed: TADDataSet: CopyDataSet was broken
• fixed: TADDataSet: FetchAll may lead to unlimited recursion for cloned datasets
• fixed: AD-0181: AV at inserting new record into empty dataset when locking is on
• fixed: TADDataSet.CopyRecord is writing to read-only fields
• fixed: DataAbstract: AnyDAC DAD may raise a "Parameter data type is changed" exception
• fixed: DataSnap: server may hang-up on exiting, if before was a database error
• fixed: DataSnap: TDataSetProvider fails to use multiple result sets of the single command
• fixed: TADScript: AV at executing a SQL command of 4092 byte length or greater
• fixed: dynamically added connection definition does not inherit the tracing and monitor parameters in the ADSettings section
• fixed: $(TEMP)\trace$(NEXT).txt fails to return next file name
• fixed: {IIF} escape sequence fails, if any of values contains ')'
• fixed: dtGUID to dtWideString / dtAnsiString value coversion was broken
• fixed: installer fails to detect D5-D7 Professional SKU
• fixed: AnyDAC fails to compile on Korean Windows
• fixed: D2009 does not register field classes introduced in D2009
• fixed: fails to open the demos in IDE, as some of the GUIx components are not registered
• fixed: few ADExplorer issues
• fixed: PgSQL, MySQL, IB: unified TypeName format (removed length, precision, scale)
• fixed: PgSQL: bind by number, output parameter, CliObj, TID handling issues
• fixed: AD-0193: Demo: CachedUpdates demo fails on few DBMS's
• fixed: PgSQL: issues are demo database installation
• fixed: AD-0192: Blobs demo does not work
• fixed: AD-0191: GUIx: LoginDialog/Main demo does not work
• fixed: AD-0190: MSSQL: "Connection is busy" if to open few meta-data cursors
• fixed: AD-0189: MemTab: Appending record to a DS with nested dataset raised AV
• fixed: AD-0188: ADExplorer does not show the MySQL database names
• fixed: AD-0187: Second call to the CloneDataset for the same DS fails
• fixed: AD-0186: CmdGen: Update SQL Editor generates incorrect FetchRowSQL
• fixed: AD-0185: TADDataSet: After failed posting of an insert to DB, record position will be changed to bottom
• fixed: AD-0184: IB: [AnyDAC][DApt]-400 on posting new record using INSERT ... RETURNING