SQLite Data Access Components (LiteDAC) Releases

Released: Feb 19, 2024

Updates in 6.1.0

Funktionen

  • Added support for Lazarus 3.0.
  • Added RealAsDouble option to Connection component.

Fehlerkorrekturen

  • Fixed bug with detecting foreign key columns in the MetaData component.

Released: Nov 15, 2023

Updates in 6.0.0

Funktionen

  • Direct mode is now based on version 3.42.0 of the SQLite engine.
  • Added support for Embarcadero RAD Studio 12 Athens.
  • Added support for Apple macOS Sonoma.
  • Added support for Apple iOS 17.
  • Added support for Android 13.
  • 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.

Fehlerkorrekturen

  • Fixed bug with incorrect execution of an SQL statement that contains a comment at the end...

Released: Mar 17, 2023

Updates in 5.3.0

Funktionen

  • 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 GUID fields stored in binary format.
  • 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...

Released: Sep 12, 2022

Updates in 5.2.0

Funktionen

  • Direct mode is now based on version 3.39.2 of the SQLite engine.
  • 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.
  • Query and Table components add 'CloneCursor' method which allows you to share data between datasets.
  • Improved performance when exporting to XML.

Fehlerkorrekturen

  • Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type.
  • Fixed bug...

Released: Apr 12, 2022

Updates in 5.1.1

Funktionen

  • 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.
  • Direct mode is now based on version 3.37.2 of the SQLite engine.

Fehlerkorrekturen

  • Fixed bug with an empty value of a string field when the database column stores data larger than the field size.
  • Fixed bug with incorrect DATETIME values handling when DateFormat and TimeFormat connection options are set to non-default...

Released: Dec 9, 2021

Updates in 5.0.2

Funktionen

  • Added PoolId connection option.

Fehlerkorrekturen

  • Fixed bug with memory leak when using the julianday() SQL function in 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 updating the state of records at applying cached updates.

Released: Sep 13, 2021

Updates in 5.0.1

Funktionen

  • Added support for Embarcadero RAD Studio 11 Alexandria.
  • Added support for Apple macOS ARM.
  • Added a demo project for FastReport FMX.
  • Added IntegerAsLargeInt option to Connection component.

Fehlerkorrekturen

  • 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 mapping.
  • Fixed bug with escaping wildcards in the...

Released: Jul 14, 2021

Updates in 4.4.4

Funktionen

  • Added support for TFieldOptions.

Fehlerkorrekturen

  • Fixed bug with applying both Encryption and Data Type Mapping on a BLOB column.
  • Fixed bug with AV after adding the Lookup field to a prepared DataSet.

Released: Apr 6, 2021

Updates in 4.4.3

Funktionen

  • JournalMode - Added jmDefault option value for the Connection component.

Fehlerkorrekturen

  • Fixed bug with mapping the liteNull database type to the ftBLOB field type.
  • Fixed bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method.

Released: Mar 26, 2021

Updates in 4.4.2

Funktionen

  • Added support for Lazarus 2.0.12.

Fehlerkorrekturen

  • Fixed a bug with setting the Locking Mode option.
  • 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.