SQL Server Data Access Components (SDAC) 新版本發表

Released: Feb 19, 2024

11.1.0 中的更新

特性

  • Added support for Lazarus 3.0.

修補程式

  • Fixed bug with preparing Stored Procedure execution.
  • Fixed bug with setting parameter values on record posting.
  • Fixed bug with SQL Generator in the design-time when the database name must be quoted.

Released: Nov 15, 2023

11.0.0 中的更新

特性

  • Added support for Embarcadero RAD Studio 12 Athens.
  • Added support for Microsoft SQL Server 2022.
  • Added support for Apple macOS Sonoma.
  • Added support for Apple iOS 17.
  • Added support for Android 13.
  • Added 'AddDateTimeFormat' option to the Dump component.
  • Added support for nested macros in SQL queries.
  • Added Display Format for Aggregate fields.
  • Added support for SHA-2 (SHA-256, SHA-512) in hash encryption algorithms.
  • Added 'LastInsertId' property to 'TMSSQL' and 'TMSQuery'.

修補程式

  • Fixed bug...

Released: Mar 17, 2023

10.3.0 中的更新

特性

  • Added support for Embarcadero RAD Studio 11 Alexandria Release 3.
  • Added support for Apple iOS Simulator target platform.
  • Added support for Lazarus 2.2.6.
  • Added support for YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter.
  • Added support for mathematical operations in TDADataSet.Filter.
  • Added support for Aggregate Fields and InternalCalc Fields.
  • Added the ability to restore from file with TEncoding via the Dump component...

Released: Sep 12, 2022

10.2.0 中的更新

特性

  • Added support for Embarcadero RAD Studio 11 Alexandria Release 2.
  • Added support for Lazarus 2.2.2.
  • Added support for Apple iOS 15.
  • Added support for Android 12.
  • Added support for Microsoft OLE DB Driver in Microsoft SQL Server 9.
  • Added support for Microsoft Azure Active Directory authentication support for the Microsoft OLE DB provider.
  • Added support for 'Always On' availability group in Direct mode.
  • Added support for connecting to Azure databases using the 'Redirect' connection policy in...

Released: Apr 12, 2022

10.1.1 中的更新

特性

  • Added support for Embarcadero RAD Studio 11.1 Alexandria.
  • Added support for Lazarus 2.2.0.
  • Added support for Microsoft Windows 11.
  • Added support for Apple macOS Monterey.
  • Added the ability to pass 'client_interface_name' parameter to the server in Direct mode.

修補程式

  • Fixed bug with adding a condition to the WHERE clause on calling the AddWhere method.
  • Fixed bug with a "Cannot modify a read-only dataset" on Delete where all fields are read-only.
  • Fixed bug with executing batch operations when...

Released: Dec 9, 2021

10.0.2 中的更新

特性

  • Added PoolId connection option.

修補程式

  • Fixed bug with setting the port number to the Server property in Direct mode.
  • Fixed bug with Varchar(max) and Text OUT parameters in Direct mode.
  • Fixed bug with describing string params in the Direct mode.
  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable.
  • Fixed bug with freezing multiply connection pools in threads.
  • Fixed bug with using the AsDate property when working with fields of the ftDate type.
  • Fixed bug with...

Released: Sep 13, 2021

10.0.1 中的更新

特性

  • Added support for Embarcadero RAD Studio 11 Alexandria.
  • Added support for Apple macOS ARM.
  • Added a demo project for FastReport FMX.

修補程式

  • Fixed bug with using the NonBlocking mode from threads.
  • Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters.
  • Fixed bug with setting a DateTime value before the year 1800 to TTimeField.
  • Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component.
  • Fixed bug with memory leak on Locate by field with data type...

Released: Jul 14, 2021

9.4.4 中的更新

特性

  • Added support for TFieldOptions.
  • Improved Index metadata retrieval for OLE DB providers.

修補程式

  • Fixed bug with applying both Encryption and Data Type Mapping on a BLOB column.
  • Fixed bug with AV when encrypting a field.
  • Fixed bug with closing an SSL connection in the Direct mode.
  • Fixed bug with processing transactions in TMSLoader.
  • Fixed bug with a Range check error when fetching more than 255 columns.
  • Fixed bug with 'Unknown datatype (24)' when creating a dump.
  • Fixed bug with AV after adding...

Released: Apr 6, 2021

9.4.3 中的更新

修補程式

  • Fixed bug a string parameter getting trimmed.
  • Fixed bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method.

Released: Mar 26, 2021

9.4.2 中的更新

特性

  • Added support for Lazarus 2.0.12.

修補程式

  • Fixed a bug with the data type mapping of varbinary fields.
  • Fixed a bug with the ConvertEOL connection option.
  • Fixed a bug with AV in applications using DBMonitor.
  • Fixed a bug with committing a transaction when LockMode = lmPessimistic.
  • Fixed a bug with getting values of calculated fields.