SQLite Data Access Components History

6.3.1 24-Oct-24

Restored support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.6

6.3.0 27-Sep-24

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.4
Added the EnableAutoInc option for LiteTable and LiteQuery components
Added the WriteBOM property for TLiteDumpOptions
Fixed bug with incorrect value when updating a float-type column in a 32-bit application on Windows ARM

6.2.1 01-May-24

Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
Fixed internal bug with TSharedObject

6.2.0 24-Apr-24

Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Now the Direct mode is based on version 3.45.2 of the SQLite engine
Added support for automatic detection of transaction state when the transaction is controlled by an SQL statement
Fixed bug with using the SQLCiper library

6.1.0 19-Feb-24

Added support for Lazarus 3.0
The RealAsDouble option for the Connection component is added
Fixed bug with detecting foreign key columns in the MetaData component

6.0.0 15-Nov-23

Now the Direct mode is based on version 3.42.0 of the SQLite engine
Added support for RAD Studio 12
Added support for macOS Sonoma
Added support for iOS 17
Added support for Android 13
Added support for nested Macros in SQL queries
Added support Display Format for Aggregate fields
Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
Fixed bug with incorrect execution of an SQL statement that contains a comment at the end
Fixed bug with ambiguity of "size_t" declaration when compiling in CBuilder
Fixed bug with moving the cursor when using Aggregate fields
Fixed bug with deleting a record when using Aggregated fields
Fixed bug with storing empty Aggregates collection in DFM
Fixed bug with AV when installing a package in the IDE
Fixed bug with AV in the CloneCursor method of the dataset
Fixed bug with using Aggregated and InternalCalc fields together
Fixed bug with duplicate resource IDs in CBuilder
Fixed bug with using "NOT Field LIKE" construction in Filter property

5.3.0 17-Mar-23

Added support for RAD Studio 11 Alexandria Release 3
Added support for iOS Simulator ARM 64-bit target platform
Added support for Lazarus 2.2.6
Added support for GUID fields stored in binary format
Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
Added support for the mathematical operations in TDADataSet.Filter
Added support for Aggregate Fields and InternalCalc Fields
Added ability to restore from file with TEncoding via the Dump component
Improved reading fields of the BLOB family
Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames

5.2.0 12-Sep-22

Now the Direct mode is based on version 3.39.2 of the SQLite engine
Added support for RAD Studio 11 Alexandria Release 2
Added support for Lazarus 2.2.2
Added support for iOS 15
Added support for Android 12
Added the CloneCursor method for Query and Table components that allows sharing data between datasets
Improved the performance of exporting to XML
Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
Fixed bug with mapping table columns of integer types to string fields
Fixed bug when a connection string parameter value contains a single quote

5.1.1 12-Apr-22

RAD Studio 11 Alexandria Release 1 is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
Now the Direct mode is based on version 3.37.2 of the SQLite engine
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 values
Fixed bug with handling DATETIME values that contains the "Z" suffix in milliseconds
Fixed bug with resetting param values when changing param values count

5.0.2 09-Dec-21

The PoolId connection pool option is added
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

5.0.1 13-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Added demo project for FastReport FMX
Added the IntegerAsLargeInt option for the Connection component
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 memoty leak on Locate by field with data type mapping
Fixed bug with escaping wildcards in the Filter property of the DataSet component
Fixed bug with mapping VARCHAR columns with length greater than 65,535 to fields of type ftString

4.4.4 14-Jul-21

Support for TFieldOptions is added
Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
Bug with AV after adding the Lookup field to a prepared DataSet is fixed

4.4.3 06-Apr-21

JournalMode = jmDefault option value for the Connection component is added
Bug with mapping the liteNull database type to the ftBLOB field type is fixed
Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

4.4.2 26-Mar-21

Lazarus 2.0.12 is supported
Bug with setting the Locking Mode option is fixed
Bug with the ConvertEOL connection option is fixed
Bug with AV in applications using DBMonitor is fixed
Bug with committing a transaction when LockMode = lmPessimistic is fixed
Bug with getting values of calculated fields is fixed

4.4.1 02-Mar-21

RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
The JournalMode option in the Connection component is added
The LockingMode option in the Connection component is added
The Synchronous option in the Connection component is added
Performance with default values of the new options is significantly improved
Performance of batch operations is improved
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
Bug with setting the ReadOnly field property at runtime is fixed
Bug with an outdated version of the SQLite engine on the Android 64-bit platform is fixed

4.3.2 14-Sep-20

Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed

4.3.1 26-Aug-20

Lazarus 2.0.10 and FPC 3.2.0 are supported
Performance of Batch Insert, Update, and Delete operations is improved
Bug with Data Type Mapping to the ftLargeint field type is fixed

4.2.4 01-Jun-20

RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
Bug with locating a record by a fixed string column in the Chinese locale is fixed
Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed

4.1.3 10-Mar-20

Bug with installing different editions of two or more DAC's in a single system is fixed
Bug with opening a query containing aggregate fields with the SmartFetch property set to True is fixed
Bug with SQL statements that contain fields with the same name from different tables is fixed
Bug with executing SQL statements that contain comments using the Script component is fixed
Bug with resetting the value of the parameter after adding a new TDACondition is fixed
Bug with reading a field value using the AsBytes method in Lazarus is fixed
Bug with using constraints after calling the Refresh method is fixed

4.1.2 26-Nov-19

Android 64-bit is supported
Lazarus 2.0.6 is supported
Now Trial edition for macOS and Linux is fully functional
Bug with AV failure when using encryption is fixed
Bug with using the FieldOrigins property is fixed
Bug with the Loader component when UniDirectional set to True for source dataset is fixed
Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
Bug with mapping to BCD fields when TClientDataSet is used is fixed
Bug with resetting the range values when executing the Refresh method is fixed
Bug with AV when executing the INSERT operation is fixed
Bug with a wrong default value of a DATETIME field when inserting a record is fixed
Bug with mapping a MEMO field to a floating-point field type is fixed
Several bugs that occurred when using DataSet Manager are fixed

4.0.1 22-Jul-19

macOS 64-bit is supported
Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
Bug with possible data corruption when encrypting a database which contains open datasets is fixed
Bug with applying aggregate functions on fields with null values is fixed
Bug with AV when using user-defined functions is fixed
Bug with using the AsMemo method in batch operations is fixed

3.5.11 24-Jun-19

Lazarus 2.0.2 is supported
Now the Direct mode is based on the version 3.27.2 of the SQLite engine
Multi-threading support is improved
The DefaultSortType property for TVirtualTable is added
Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
Bug with using the LIKE clause in a query is fixed
Bug with the AV failure when executing the Refresh method is fixed
Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
Bug with using the SetRange method is fixed

3.4.10 21-Jan-19

Now the Direct mode is based on the SQLite engine version 3.26.0
Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

3.4.9 26-Nov-18

RAD Studio 10.3 Rio is supported
Support for the BreakExec method in the Query component is added
Support of UPPER and LOWER functions for Unified SQL is added
Bug in TLiteDump with dumping national characters when UseUnicode is True is fixed
Bug with using the FieldOrigins property is fixed
Bug with using the TrimFixedChar property is fixed
Bug with saving a dataset that contains BLOB fields to XML is fixed

3.3.8 17-Sep-18

Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
Now the SetRange method supports Null values
The enumerated property FieldOrigins is added
The Boolean property FieldsOrigin is deprecated
Bug with AV when using custom constraints is fixed
Bug with reading DATETIME field values that have milliseconds is fixed

3.3.7 13-Jul-18

Bug with detection of field data types is fixed

3.3.6 09-Jul-18

Lazarus 1.8.4 is supported
Performance of batch operations is improved
Demo projects for IntraWeb 14 are added
WAL in the Direct Mode for non-Windows platforms is supported
Memory leak in NEXTGEN is fixed
Bug with retrieving data in a Detail dataset having SmartFetch enabled is fixed
Bug with AV on macOS High Sierra is fixed
Bug with updating a record when using the OnFilterRecord event handler is fixed
Bug with using encryption and CacheCalcFields option is fixed
Bug with using a backslash in the Filter property is fixed
Bug with using First method in the Master-Detail relationship is fixed

3.2.5 02-Apr-18

Lazarus 1.8.2 is supported
Now Detail dataset is not refreshed when Master dataset editing is started
Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
Bug with re-opening a filtered dataset is fixed
Bug with data decryption in SmartFetch mode is fixed
Bug with data truncation while decrypting is fixed
Bug with the TrimFixedChar dataset option is fixed

3.2.4 18-Jan-18

Direct Mode in Lazarus is supported
Lazarus 1.8 and FPC 3.0.4 are supported
BIT type is supported
Support for custom constraints is added
The UseBlankValues property for the Loader component is added
The TLiteDataSetOptions.UnknownAsString property that allows mapping fields of unknown type as ftString instead of ftMemo is added
The TLiteDataSetOptions.AdvancedTypeDetection property that allows describing columns having data of different types is added
Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
Bug with assertion failure when using the OnFilterRecord event handler is fixed
Bug with script parsing in TDAScript is fixed
Bug with AutoInc fields in TVirtualTable is fixed
Bug with AV in TVirtualDataSet when editing Blob is fixed

3.1.3 19-Sep-17

Now the Direct mode is based on the SQLite engine version 3.20.0
Custom SQL aggregate functions are supported
Bug with opening an existing database on iOS 64 is fixed
Bug with international symbols in non-Unicode Delphi versions is fixed
Bug with detecting field types is fixed
Bug with low performance of the LoadFromDataSet method of the Loader component is fixed
Bug with index backup using the Dump component when the TableNames property is set is fixed
Bug with generating SQL for batch updates is fixed
Bug with the Locate method for non-Windows platforms in Lazarus is fixed
Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
Bug with accessing a product help from the IDE menu is fixed
Bug with recreating fields when calling Open after Prepare is fixed
Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
Bug with AV failure when using calculated fields in TClientDataset is fixed
Bug with a key violation error when executing batch operations is fixed
Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
Bug with using DAC components in DataModule for Linux is fixed

3.0.2 15-May-17

Bug with creating a database in the Direct Mode on Android is fixed
Bug with processing NULL values in the Loader component is fixed
Bug with executing a query after executing a batch command is fixed
Bug with using the AsGuid property is fixed

3.0.1 05-Apr-17

RAD Studio 10.2 Tokyo is supported
Linux in RAD Studio 10.2 Tokyo is supported
Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
Now the Direct mode is based on the SQLite engine version 3.17.0
Bug with VACUUM command in the Direct mode is fixed
Bug with query parameters binding is fixed
Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
Bug with detecting parameters by name in ExecSQLEx is fixed
Bug with reading Memo as WideMemo is fixed
Bug with field name quoting in a filter expression is fixed
Bug with handling parameter values of BLOB type in batch operations is fixed
Bug with memory leak in TVirtualDataSet is fixed

2.7.27 21-Nov-16

Bug with adding Calculated fields after calling Prepare is fixed
Bug with using field names with spaces in the Master-Detail relationship is fixed

2.7.26 01-Nov-16

Now the Direct mode is based on the SQLite engine version 3.15.0
Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
Bug with handling comments in a SQL statement is fixed
Bug with batch operations in the Direct Mode on Android is fixed
Bug with batch operations in the Direct Mode on Mac OS X is fixed

2.7.25 08-Sep-16

TDADataSetOptions.InsertAllSetFields property is added
Several bugs in SmartFetch Mode are fixed
Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
Bug with param values loss after changing TDAParam.ValueCount is fixed
Bug with PtrOffset function when Overflow Checking option enabled is fixed
Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
Bug with the duplicated MacroChar variable is fixed

2.7.24 27-Jun-16

TVirtualDataSet component is added
Bug with assertion failure on editing data in SmartFetch mode is fixed
Bug with AV on application closing when DLLs are used in the Trial edition is fixed
Bug with using parameters and column aliases in Master-Detail relation is fixed

2.7.23 28-Apr-16

Bug with AV failure when connection is not specified is fixed
Bug with batch operations is fixed

2.7.22 25-Apr-16

RAD Studio 10.1 Berlin is supported
Lazarus 1.6 and FPC 3.0.0 is supported
Support for the BETWEEN statement in TDADataSet.Filter is added
Now the Direct mode is based on the SQLite engine version 3.12.0
Support for URI filenames is added
Bug with handling international characters in the VirtualTable component is fixed
Bug with displaying data in grid on error at applying cached updates is fixed
Bug in the SetOrderBy method in case when SQL contains ';' is fixed
Bug with using the LIKE clause in a dataset filter is fixed
Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
Bug with query parameters is fixed
Bug with AV using Delphi 7 is fixed
Bug with memory leaks using C++ Builder 10 Seattle is fixed
Bug with AV on iOS 64 is fixed
Bug with generating of UpdateSQL on using WITH clause is fixed

2.6.21 01-Feb-16

Data Type Mapping performance is improved
SQLite engine version is rolled back to 3.8.11.1 for Direct mode due to unstable functioning
Bug with "File IO error" in Direct Mode on Android platform is fixed
Bug with inserting table data in Lazarus is fixed
Bug with using parameters in multi-SQL is fixed

2.6.20 14-Dec-15

Now the Direct mode is based on the SQLite engine version 3.9.2
Performance of TDALoader on loading data from TDataSet is improved
Several bugs in the SmartFetch mode are fixed
Bug with processing the cached data in the ApplyUpdates method is fixed
Bug with RecNo in the Unidirectional mode is fixed
Bug with storing some numbers with floating point is fixed
Bug with the "I/O Error" error in Direct Mode on Mac OS X is fixed
Bug with AV in Direct Mode in CBuilder x64 is fixed

2.6.19 18-Sep-15

Bug with showing values array for batch updates in SQLMonitor is fixed
Bug with editing Blob and Memo fields used in local filter is fixed

2.6.18 09-Sep-15

RAD Studio 10 Seattle is supported
INSERT, UPDATE and DELETE batch operations are supported
Now Trial for Win64 is a fully functional Professional Edition
Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
Now the Direct mode is based on the SQLite engine version 3.8.11.1
The EnableSharedCache option of the Connection component for non-Windows platforms is added
Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
SQLMonitor behavior on using similar objects is fixed
Bug with endless reconnection in assigned connection is fixed
Bug with editing Blob and Memo fields used in local filter is fixed
Bug with a null CURRENT_TIME value on MacOS, iOS & Android in Direct Mode is fixed
Bug with handling DATETIME fields with milliseconds is fixed
Bug with attaching a database containing international characters in the encryption key is fixed
Bug with database encryption in Direct Mode on MacOS is fixed
Bug with the "Unable to open database" error when using a temp database on Android is fixed
Bug with CRBatchMove component when using complex table names is fixed
Bug when calling SQL for trigger creation is fixed
Bug with detecting AutoInc fields on mobile platforms is fixed

2.5.17 14-Jul-15

Critical bug with data encryption is fixed
Bug in IProviderSupport.PSExecuteStatement with parsing a SQL query is fixed
Bug with missing IdeVer.inc in Trial version is fixed
Bug with updating a dataset containing complex primary key is fixed

2.5.16 30-Jun-15

Bug when parsing SQL query with parameters is fixed
Bug with the Refresh method in the SmartFetch mode is fixed
Bug with AutoInc fields on mobile platforms is fixed

2.5.15 17-Jun-15

Now the Direct mode is based on the SQLite engine version 3.8.10.2
Bug with Code Editor in the design-time is fixed
Bug with the "Local time unavailable" error in Direct mode on x64 platform is fixed
Bug "Unit LiteStatic was compiled with a different version of LiteCall.TSQLite3API" for iOS 32-bit is fixed
Bug with using bookmarks in a filtered dataset is fixed
Bug with restoring the original order of records after clearing IndexFieldNames is fixed
Bug with refreshing DbLookupComboBox of the detail dataset when Master-Detail relationship is used is fixed
Bug with SQL Monitor freezing when using in a DLL is fixed

2.5.14 14-Apr-15

RAD Studio XE8 is supported
AppMethod is supported
Direct mode for Mac OS X, iOS and Android platforms is supported
Database encryption for Mac OS X, iOS and Android platforms is supported
Now the Direct mode is based on the SQLite engine version 3.8.9
The TLiteConnection.Options.ConnectMode property is added
The TLiteConnection.ReleaseDatabaseMemory method is added
The TLiteConnection.IsDatabaseReadOnly method is added
Converter from liteNull data formats to ftExtended is added
Bug with invalid names of Master-Detail parameters is fixed
Bug with AV on calling GetVersion() in C++Builder is fixed
Bug with installing both LiteDAC and UniDAC Express is fixed
Bug with a zero-valued LastInsertID result is fixed

2.4.13 14-Jan-15

Lazarus 1.2.6 is supported
Now the Direct mode is based on the SQLite engine version 3.8.7.4
Bug with losing data after VirtualTable closing on SaveToStream is fixed
Bug with RestoreUpdates in CachedUpdates mode is fixed
Bug with AV when connecting in the Direct mode on x64 platform is fixed

2.4.12 25-Nov-14

Now the Direct mode is based on the SQLite engine version 3.8.7.1
CRBatchMove component registration is added.
Bug when using table aliases in the DetailFields name is fixed
Bug with using UPPER and LOWER functions in filter is fixed
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
Bug with TCustomDADataSet.FindKey is fixed
Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
Bug with 'Thread Error' when connecting on OS X is fixed
Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed
Bug with detection of auto-incremental field is fixed
Bug with retrieving a table index list using the MetaData component on non-Windows platforms is fixed
Bug with unnecessary preparing of a DML-statement when a dataset is opening is fixed

2.4.11 29-Sep-14

ConnectionTimeout is now used on OSX and Mobile platforms
Bug with RecNo in the UniDirectional mode is fixed
Bug with setting SQL query when ParamCheck = False is fixed
Bug with AV failure on getting metadata by TCustomDADataSet is fixed
Bug with AV failure under Mobile when DacFMX is used is fixed
Bug with fetching WideString fields is fixed
Bug with detection of auto-incremental field is fixed

2.4.10 15-Sep-14

RAD Studio XE7 is supported
Lazarus 1.2.4 is supported
Demo projects for FastReport 5 are added
The TCustomDADataSet.GetKeyFieldNames method is added
The TCustomDAConnection.GetKeyFieldNames method is added
The ConstraintColumns metadata kind for the TDAMetadata component is added
Now the Direct mode is based on the SQLite engine version 3.8.6
TLiteBackup component is added
Several bugs in the SmartFetch mode are fixed
Bug with quoting names in the EmptyTable method is fixed
Bug with calling the Refresh method after executing the EmptyTable method is fixed
Bug with setting calculated field values using the AsExtened property is fixed
Bug with re-calling the AfterExecute event is fixed
Bug with re-calling the BeforeExecute event is fixed
Several bugs with metadata retrieving are fixed
Bug with mapping TIMESTAMP columns to float fields is fixed

2.3.9 31-Jul-14

Support for the Upper and Lower statements in TDADataSet.Filter is added
Support for the ftOraTimeStamp type in TVirtualTable is added
The SQL property is added to TLiteConnection
SQLite Online Backup is supported
The TLiteTable.EmptyTable method is added
Bug with reopening TDADataSet after BreakExec is fixed
Several bugs in the SmartFetch mode are fixed
Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
Bug with getting RecordCount when QueryRecordCount is True is fixed
Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
Bug with "Invalid field size" in TVirtualTable is fixed
Bug with AV failure on freeing objects on mobile platforms is fixed

2.3.8 27-May-14

Bug with compilation in C++Builder is fixed
Bug with setting boolean parameters in a non-English IDE at design-time is fixed
Bug with AV failure on fetching records in the UniDirectional mode is fixed
Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed

2.3.7 29-Apr-14

RAD Studio XE6 is supported
Android in C++Builder XE6 is supported
Lazarus 1.2.2 and FPC 2.6.4 is supported
SmartFetch mode for TDataSet descendants is added
The TLiteDataSetOptions.MasterFieldsNullable property is added
Now the Direct mode is based on the SQLite engine version 3.8.4.3
The EnableLoadExtension option is added for the Connection component
Now update queries inside TDataSet descendants have correct owner
The SetOrderBy method behavior is fixed
The GetOrderBy method behavior is fixed
Bug with displaying already installed DAC version in setup messages is fixed
Bug with the Filter behavior in the Metadata component is fixed
Bug with AV on modify table with one only Object field is fixed
Bug with Locate when a NULL value is present in the index field is fixed
Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
Bug with freeing memory in the TDADataSet.Lookup method is fixed

2.2.6 19-Feb-14

Now the Direct mode is based on the SQLite engine version 3.8.3.1
Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
Support for Delphi DateTime format is added
Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
Bug with opening dataset when persistent fields were created in dataset is fixed
Bug with parameter name quoting on assigning field value to parameter is fixed
Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
Bug on sorting BLOB fields is fixed
Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed
Bug with generating SQL queries by "SQL Generator" in design-time is fixed
Bug with using '$' and '#' symbols in a parameter name is fixed

2.2.5 25-Dec-13

iOS in C++Builder XE5 is supported
Direct mode for x64 platform is supported
Now the Direct mode is based on the SQLite engine version 3.8.2
RAD Studio XE5 Update 2 is now required
Now .obj and .o files are supplied for C++Builder
Compatibility of migrating floating-point fields from other components is improved
Bug with data loss when updating records in the CachedUpdates mode is fixed
Bug with RefreshRecord in the CachedUpdates mode is fixed
Bug with mapping to BCD and FmtBCD types is fixed
Bug with mapping single types to float types is fixed
Bug with data display in Detail Dataset when master field is Null is fixed
Bug with mapping to BCD fields when using TClientDataSet is fixed
Bug with incorrect parameter sizes when re-opening a query is fixed
Bug with filtering boolean fields is fixed
Bug with freeing complex fields after refreshing before editing is fixed
Bug with Locate by fields where Data Type Mapping is applied is fixed
Bug with RefreshQuick when IndexFieldNames is set is fixed
Bug with executing multi-SQL statements is fixed

2.1.4 23-Sep-13

Critical bug with parsing unicode SQL queries is fixed

2.1.3 18-Sep-13

RAD Studio XE5 is supported
Application development for Android is supported
Lazarus 1.0.12 is supported
Performance is improved
Automatic checking for new versions is added
Flexible management of conditions in the WHERE clause is added
Now the Direct mode is based on the SQLite engine version 3.8.0.2
The TLiteUserCollation component is added
Support of the IN keyword in the TDataSet.Filter property is added
Like operator behaviour when used in the Filter property is now similar to TClientDataSet
The possibility to use ranges is added
The Ping method for the Connection component is added
The AllowImplicitConnect option for the Connection component is added
The SQLRecCount property for the Query and StoredProc components is added
The ScanParams property for the Script component is added
The RowsAffected property for the Script component is added
The 'True' Boolean value is now saved in the database as 1
Conversion from the liteText type to all the supported types is added.
Bug in TDALoader with data loading from Dataset when the FetchAll option is set to False is fixed
Bug with TDALoader.LoadFromDataSet is fixed
Bug with storing the dbMonitor active state to DFM is fixed
Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
Bug with processing cached data when UpdateRecordTypes is not default is fixed
Bug with moving data from WideMemo to String fields by TCRBatchMove is fixed
Bug in TCRBatchMove when destination dataset has no key fields is fixed
Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
Bug with setting the connection string containing inline comments is fixed
Bug with unnecessary unlock calling after an update error is fixed
Bug with AssignConnect from a disconnected source connection is fixed
Bug with an incorrect datetime (date, 'localtime') function result in the Direct mode is fixed
Bug with data mapping to the Currency data type is fixed
Bug with detecting auto-increment fields is fixed

2.0.2 15-Jul-13

Connection dialog is improved
Now the Direct mode is based on the SQLite engine version 3.7.17
Now the UNKNOWN data type is mapped as ftMemo
Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
Support for Unix and Julian date and time formats is improved
Bug with incorrect column type determination when metadata API is unavailable is fixed
Bug with avg(), count(), max() & last_insert_rowid() functions on Mac OS X is fixed
Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
Bug with the connection OnLogin event is fixed
Bug with incorrect counting of connections in pool is fixed
Bug with time fields in Lazarus is fixed
Bug with varbinary fields in Lazarus is fixed
Bug with using case-insensitive filter is fixed
Bug with getting and setting the SQL property of FastReport datasets is fixed
Bug with positioning of Fields Editor is fixed
Bug with not using index fields on locating records is fixed
Bug with processing the cached data when UpdateRecordTypes is not default is fixed
Bug with processing persistent fields in TVirtualTable is fixed

2.0.1 25-Apr-13

Rad Studio XE4 is supported
NEXTGEN compiler is supported
Application development for iOS is supported
Connection string support is added
Possibility to encrypt entire tables and datasets is added
Possibility to determine if data in a field is encrypted is added
Support of TimeStamp, Single and Extended fields in VirtualTable is added
Now the Direct mode is based on the SQLite engine version 3.7.16.2
Now SQLite string data type without length is mapped as ftMemo instead of ftString
Converter from Unix and Julian data formats to ftDateTime is added
Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
Bug with Master-Detail by non-English fields is fixed
Bug with IndexFieldNames by non-English fields is fixed
Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
Bug with calling Cancel in the BeforePost event is fixed
Bug when setting the TDataSet.Filter property for empty dataset is fixed
Bug with incorrect TVirtualTable version displaying in the About box is fixed
Thread handle leak when using pooling is fixed
Bug with TLiteLoader.LoadFromDataSet when UniDirectional = True and FetchRows = 1 is fixed
Bug with TLiteLoader.AutoCommit in PutData mode is fixed
Now the TCustomDASQLMonitor.Options.moDBMonitor property is set to False by default

1.6.5 14-Feb-13

Rad Studio XE3 Update 2 is now required
Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
Bug with assigning data to blob fields when using Data Type Mapping is fixed
Bug with inserting a new record into TStringGrid in FMX is fixed
Bug with unlocking a record after constraint violation is fixed
Bug with quoting index field names in TCRDBGrid is fixed
Bug with Master-Detail link by fields with non-English names is fixed
Bug in TLiteConnection.EncryptDatabase when using a third-party sqlite3.dll is fixed

1.6.4 12-Dec-12

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported
LastInsertId property for TLiteSQL and TLiteQuery is added
Bug with using quoted field names in the IndexFieldNames property is fixed
Bug in TLiteStoredProc with closing dataset when the Disconnected property is True is fixed
Bug with processing macros named in Cyrillic is fixed
Bug with disabling some components on ToolPalette for x64 and Mac OS X platforms is fixed
Bug with field default values when using field aliases is fixed
Bug with mapping integer fields to float data type is fixed

1.5.3 07-Nov-12

Some improvements for NEXTGEN support are added
Support for ftGraphic and ftFmtMemo parameter data types is added
Informativity of messages about errors in connection is improved
Now the Direct mode is based on the SQLite engine version 3.7.14.1
FTS3 and FTS4 support is added in the Direct mode
The TLiteLoader component performance is significantly increased
Dependency of design-time packages on FMX packages is removed
Bug with data loss in pessimistic lock mode is fixed
Bug with AV failure in RefreshQuick method is fixed
Bug with renaming of fields with the same names is fixed
Bug with dependency parameters count in macros on delimeter is fixed
Bug with storing the LoginPrompt connection property is fixed
Bug with dump data from VIEW is fixed
Bug with creating columns on setting the TableName property in TDALoader is fixed
Bug with setting the TLiteQuery.Active property to True in design-time is fixed
Bug with attaching an encrypted database is fixed

1.5.2 04-Sep-12

Rad Studio XE3 is supported
Windows 8 is supported
Now the Direct mode is based on the SQLite engine version 3.7.13
Extended error codes support is added
Components for FastReport 4.0 are added
The bug with memory leak when working in Direct mode is fixed
The bug with the ForceCreateDatabase property when specifying a DB name without full path is fixed
The bug with the DecryptDatabase method when setting connection for Delphi versions since Delphi 2009 is fixed
The bug with displaying the ClientLibrary property in design-time is fixed
The bug with low performance when executing the UPDATE SQL-statement in DirectMode is fixed
The bug with changing DB page size (executing the sequence of instructions PRAGMA page_size + VACUUM) in DirectMode is fixed
The bug with storing empty MapRules collection in DFM is fixed

1.0.1 01-Aug-12

Initial release of LiteDAC