|
Added PostgreSQL support for the array and composite data types. The TADScript documented and added few demos.
------------------------------------------------------------ v 2.0.15.1163 (26.11.09) + added: PgSQL: support for array and composite types + added: Firebird: supported for trusted authentification + added: AD-0315: GUIx: Add exception handling control to the TADGUIxFormsErrorDialog + added: MSAccess: support for INSERT INTO .. DEFAULT VALUES + added: ADExplorer: added support for connection recovery + added: Demo: TADScript demos are added + added: Help: TADScript is described / changed: GUIx: "Advanced Options" captions are renamed into "Options". Few other similar changes. / changed: ADDataSet: dataset constraint error message now is more informative / changed: ADDataMove: in DS -> DS mode data move now will add to mapping only the same named fields / changed: TADScript: multiple improvement and code cleanup - fixed: DApt: AV when monitoring is enabled and SchemaAdapter is using - fixed: AD-0324: PgSQL: 44000000 is fetched as 4400 - fixed: AD-0322: ADQuery: Does not post update for a field change 0.5 -> 0.05 - fixed: MySQL: stored procedure may fail to return data correctly - fixed: Oracl: the support of inserting into a field with a sequence in a trigger was half broked - fixed: MySQL: BIT(1) is mapping to dtByteString, instead of dtBoolean - fixed: Oracl: does not support ftBoolean parameters - fixed: GUIx: syntax memo does not correctly use the Delphi syntax highlighting schema - fixed: AD-0321: ADDataSet: CopyDataSet may raise AV - fixed: TADConnection: ExecSQL and ExecSQLScalar do not route an error to the OnError event - fixed: AD-0320: ADDataSet: TField.OldValue, NewValue and CurValue does not work in TField.OnValidate - fixed: AnyDAC may fail if to compile with different aligment, than {$A8} - fixed: MySQL: stored procedure does not support BINARY / VARBINARY parameters - fixed: AD-0319: ADQuery: Multiple issues with dataset editing, locking and transaction handling - fixed: TADDataSet: "Out of bounds" if add a fkInternalCalc field after creating the normal fields - fixed: AV in ADScript when connection is losted - Oracle, MySQL, etc: fails to fetch date column with year < 1900 - Oracle: fails to fetch date column with year < 1900 - fixed: TDBX: fails to fetch resultset with ADT columns ("invalid attribute" on Oracle) - fixed: ADScript: incorrect error message when command unit is not linked - fixed: AD-0316: DatS: Constraint checking does not work on the long string columns - fixed: Conn edit: incorrect links to the wiki - fixed: ADScript: incorrect error message when command unit is not linked - fixed: AD-0313: Design time: "TByteField class is not found" exception - fixed: AD-0312: FB: Some procedures are not shown for StoredProcName ------------------------------------------------------------ v 2.0.14.1109 (27.10.09) + added: SQLite: support for PRAGMA = FOREIGN_KEYS + added: DatS: add versioning to the DatS streaming. Added TADResourceOptions.DefaultStoreVersion property. + added: TADDataSet: Add Distinct property to TADIndex / changed: Phys: now ExtendedMetaData is False by default / changed: Phys: reconnection logic will be used for setting Connected to True / changed: Phys: Ping method may be used when connection is not active / changed: better diagnostic for "factory is not found" error / changed: FR4 addon: added D2010 package files, minor fix / changed: [IB|PG]ExtendedMetaData renamed to ExtendedMetaData / changed: Tools: now is Unicode / changed: added uADStanAsync to script engine / changed: Stan: Options implementation is reworked to make it possible to implement profiles, etc. Also, now it is few ten % faster. - fixed: Installer: fails to detect environment with "invalid data type for 'Xxxx'" - fixed: AD-0286: Installer: Fails to install on D2010 Prof - fixed: Installer: fails to compile with undefined AnyDAC_MONITOR - fixed: D7: Internal error: E5916 on ADConnection.Connected := True - fixed: AD-0285: TADDataSet: Post/Next statement leads to an infinite loop - fixed: TADDataSet: assertion is failed if to call Cancel from BeforePost - fixed: TADDataSet: GetNextPacket returns 0, while there were records fetched - fixed: AD-0290: TADDataSet: FetchAll does not refresh the DB-controls - fixed: AD-0294: ASA: AnyDAC fails to connect to ASA v 11 - fixed: MSAcc 2007: "Syntax error in INSERT INTO statement" with TEXT column - fixed: ADS: few issues - fixed: ADS: does not support SQL_C_NUMERIC - fixed: AD-0307: Oracle: "Variable length data column [DUMMY] overflow" on connection transfered to DLL & UTF8 - fixed: IB: "Unavailable database" is not recognized as a losted connection - fixed: AD-0288: IB: Setting IBAdvanced=set_db_readonly=0 does not work minor changes for DBX bridge driver - fixed: AD-0305: PgSQL: CurrentSchema returns invalid data. So, metadata is not returned correctly too. - fixed: AD-0296: PgSQL: "Cannot parse object name" is raised on a query with sub-queries - fixed: AD-0295: MSSQL: Wrong TEXT value fetched from a resultset on D2009 - fixed: AD-0289: MSSQL: Fails to get metainformation, depending on server collation and other related - fixed: AD-0283: MSSQL: Index Names select for MSSQL 2000 does not work (but works with MSSQL 2005) - fixed: AD-0282: MSSQL: fails to apply RecsMax and RecsSkip to SELECT DISTINCT ORDER BY - fixed: ODBC: AV on fetching mkTableFields with Parkway ODBC driver - fixed: ODBC: Parkway Micro Focus ODBC driver fails to handle SQL_C_NUMERIC - fixed: AD-0293: ODBC: AV when CATALOG_NAME_SEPARATOR is empty - fixed: ODBC: AV on fetching using Parkway Micro Focus ODBC driver - fixed: FPC / Linux: AV when a client library is not found - fixed: FPC: fails to reprepare a query - fixed: AD-0308: DataAbstract / Advantage: DAD does not recognise Advantage AUTOINC fields - fixed: AD-0306: AV with SafeMM - fixed: Stan: improved D2010 support in RegExp - fixed: DatS: BLOB fields are reading as NULL's from XML storage - fixed: TADParam.Create has wrong argument type - fixed: ADScript: AV is possible at Destroy - fixed: AD-0301: DApt: DELETE ... WHERE ID=:ID deletes not records - fixed: ADMemTable: Seting TField.DefaultExpression does not work - fixed: Tracer: an exception is created but not raised - fixed: AD-0299: BDE: Migration of D5 TQuery to D2010 TADQuery fails - fixed: AD-0297: ADQuery: does not raise an exception if a transaction is specified without a connection - fixed: AD-0287: fails to call a SP with quoted name and a mixed identifier case - fixed: AD-0291: GUIx: Connection editor: AV at calling the editor at design time - fixed: GUIx: exception in dialog component constructors leads to an AV - fixed: AD-0311: DAbs: AnyDAC DAD fails to compile with the trial AnyDAC version ------------------------------------------------------------ v 2.0.14.1078 (09.09.09) - changed: [IB|PG]ExtendedMetaData renamed to ExtendedMetaData - changed: now ExtendedMetaData is False by default - fixed: AD-0299: BDE: Migration of D5 TQuery to D2010 TADQuery fails - fixed: AD-0297: ADQuery: does not raise an exception if a transaction is specified without a connection / changed: Phys: changed uADPhysXxxMeta to use AnsiQuotedStr / changed: ADS: few issues fixed + added: TADDataSet: Add Distinct property to TADIndex - fixed: ODBC: Parkway Micro Focus ODBC driver fails to handle SQL_C_NUMERIC - fixed: AD-0296: PgSQL: "Cannot parse object name" is raised on a query with sub-queries - fixed: ODBC: AV on fetching using Parkway Micro Focus ODBC driver - fixed: AD-0295: MSSQL: Wrong TEXT value fetched from a resultset on D2009 - fixed: AD-0294: ASA: AnyDAC fails to connect to ASA v 11 - fixed: AD-0293: ODBC: AV when CATALOG_NAME_SEPARATOR is empty - fixed: FPC / Linux: AV when a client library is not found - fixed: FPC: fails to reprepare a query - fixed: D7: Internal error: E5916 on ADConnection.Connected := True / changed: FR4 addon: added D2010 package files, minor fix - fixed: AD-0291: Connection editor: AV at calling the editor at design time - fixed: AD-0283: Index Names select for MSSQL 2000 does not work (but works with MSSQL 2005) - fixed: fails to compile with undefined AnyDAC_MONITOR - fixed: TADDataSet: assertion is failed if to call Cancel from BeforePost - fixed: TADDataSet: GetNextPacket returns 0, while there were records fetched - fixed: AD-0290: TADDataSet: FetchAll does not refresh the DB-controls - fixed: AD-0289: MSSQL: Fails to get metainformation, depending on server collation and other related - fixed: AD-0288: IB: Setting IBAdvanced=set_db_readonly=0 does not work - fixed: AD-0287: fails to call a SP with quoted name and a mixed identifier case - fixed: exception in dialog component constructors leads to an AV - fixed: AD-0286: Fails to install on D2010 Prof - fixed: AD-0285: Post/Next statement leads to an infinite loop - fixed: AD-0282: MSSQL: fails to apply RecsMax and RecsSkip to SELECT DISTINCT ORDER BY |