Version History

v2.20

• New : Support for the 64-bit IDE.
• Fixed : Better handling of lifecycle of server database instances. Previous behavior was causing issues with RemoteDB server i high-concurrency scenarios (many simultaneous requests) and short-lived database instances (quick connect and disconnect). This should be fixed now.

v2.19.0.1

• New : TXDataset.OnExecuteApplySQL event is fired before execution of each SQL statement automatically executed by the dataset, mostly when Post/Delete methods are called and AutoApply property is set. This is an opportunity to modify teh SQL statement or the parameters - sometimes it''s useful to modify the param types due to db driver incompatibilities.
• Improved : TXDataset now takes TField.Origin property into account when building SQL statements for INSERT, UPDATE and DELETE statements. If Origin property set, that value will be used as the underlying table column to be updated, inserted, queried.
• Improved : TXDataClient.RawInvokeAsync has an overload that allows passing the Query parameter. Ticket #23741.
• Improved : Better performance when opening TXDataset in an application using EurekaLog.

v2.18

• Fixed : VarBytes field data not being set with using TGenericDatabase with TADOConnection.
• Fixed : TXDataset.OnPostError not raising when using TGenericDatabase with TADOConnection and with RemoteDB server.
• Fixed : RemoteDB server not properly handling Accept-Encoding header when multiple values were provided by the client. Ticket #23218.

v2.17

• New : Delphi 12 support.

v2.16

• Fixed : Sporadic Access Violation when destroying TRemoteDBDatabase component. Ticket #19922.

v2.15

• New : TXDataset.AutoFillDetailFields property.
• Fixed : Detail dataset not being updated after master dataset was closed and reopened (regression).

v2.14

• Improved : Design-time components were greyed out in component palette if current platform was different than Win32.
• Fixed : Field Not Found error with master detail link when changing SQL. (ref: https://support.tmssoftware.com/t/field-not-found-error-with-master-detail-link-when-changing-sql/19183)
• Fixed : Access Violation when using Master-Detail field alias with double quotes as parameter (ref: https://support.tmssoftware.com/t/access-violation-when-using-master-detail-field-alias-with-double-quotes-as-parameter/19236)
• Fixed : Access Violation when closing form with TXDataset in dsInsert (ref: https://support.tmssoftware.com/t/access-violation-when-closing-form-with-txdataset-in-dsinsert/19234)

v2.13

• New : Delphi 11 support.

v2.12

• New : Linux support (Indy-based server only). You can now use RemoteDB server on Linux, using Indy-based servers.

v2.11

• Improved : Performance increase when executing SQL statements with a big number of parameteres.

v2.10

• Fixed : Events BeforeStatement and AfterStatement were not correctly passing the value of SQL parameters used in the statement.

v2.9

• Fixed : InvalidFieldSize exception in float fields when using RemoteDB with native SQL Server driver (MSSQL).
• Fixed : Duplicated field name when using native SQL Server driver (MSSQL) and the SQL statement returned ambiguous (same name) fields.

v2.8

• New : Support for native database-access drivers. You can now use TRemoteDB using the database native drivers available in TMS Aurelius. Up until this version, RemoteDB servers and TGenericDatabase could only be used with dataset-based components like FireDAC, UniDAC, dbExpress, etc.. Now you can use the native Aurelius database drivers available (except for SQLite), which don't require any component at all, and are even faster!
• Improved : Support for batch updates when using TGenericDatabase. Up to this version, only TRemoteDBDatabase was supporting batch updates.
• Improved : Significant performance improvement when defining dataset pararameters (ArraySize property) when using batch updates.
• Fixed : Settings null parameter values when using batch updates was not working.

v2.7

• New : Support for Delphi 10.4 Sydney.
• Fixed : TXDataset.AutoApply property not working when the key field itself was modified.

v2.6

• Fixed : Using two parameters with the same name, differentiated just by a number (param1, param2), the same param value were being used for both params.
• Fixed : "Field not found" when using master-detail mechanism (regression from last version).

v2.5

• New : Batch updates (Array DML) mechanism for improved performance when inserting, updating or deleting several records at the same time. It is used both client-side (to use a single request to send SQL statement and all parameters at once) and server-side (to execute a single SQL statement in the database passing all parameters for all rows.

v2.4

• New : Integration plugin for Report Builder from Digital Metaphors. More info in this Youtube video.

v2.3

• New : Support for Android 64-bit platform (Delphi 10.3.3 Rio).

v2.2

• Fixed : Error "Field is of unknown type" in blob fields when updating records using AutoApply.
• Fixed : Correct handle of fields of type ftOraClob. Now they have the same behavior as ftMemo.
• Fixed : AutoApply was not working when field names had spaces. If you were editing a record and modified a field which name had a space (like "Contact Name") and tried to Post the record using AutoApply, an error would be raised.

v2.1

• Improved : Optimizations have been implemented, performance has been improved, especially when retrieving big amount of data and/or executing many statements that use many query parameters each.
• Fixed : Previous version had broken compatibility with NexusDB integration, it's now fixed.
• Fixed : A SQL syntax error were being raised when using AutoApply and more than one field were modified by the dataset.

v2.0

• New : TRemoteDBDatabase.ClientId property allows identifying clients in server.
• New : TMS RemoteDB VCL Server Wizard makes it easy to create a new RemoteDB server application using design-time components.
• New : Server-side events OnDatabaseCreate, OnDatabaseDestroy, BeforeStatement and AfterStatement. Data is provided in IDatabaseInfo and IStatementInfo with full information about the database connections and statements being executed.
• New : Automatic data modification using TXDataset properties: AutoApply and KeyFields. Allow for automatic data modification by executing UPDATE, INSERT and DELETE SQL statements.
• New : Administration API for retrieving server status (database connections including last accessed time, client id, etc.) and dropping database connections.

v1.15

• Fixed : Basic authentication was being enforced even when UserName and Password properties were empty strings.

v1.14

• New : TRemoteDBServer component provides design-time support to create server-side RemoteDB server.
• Improved : RemoteDB simple demo updated to use the new TRemoteDBServer component.

v1.13

• Improved : Increased performance when using TGenericDatabase and executing SQL statements (non-SELECT).
• Fixed : Error when using SQL syntax with double colon, e.g. PostgreSQL type cast - ::varchar(20).

v1.12

• Fixed : TXDataset was creating invalid parameters in some situations, for example in stored procedures with code like A := B.

v1.11

• Improved : Exception raised by the client is now ERemoteDBRequestException and includes the status code of the HTTP response.

v1.10

• New : TRemoteDBDatabase.OnHttpClientCreate event.
• New : TRemoteDBDatabase.BeforeConnect and AfterConnect events.
• Improved : TXDataset.Execute function now returns the number of rows affected by the operation.

v1.9.1

• New : TXDataset.ParamByName method.

v1.9

• New : TRemoteDBDatabase.OnRequestSending property.

v1.8

• Improved : RemoteDB IDBStatement now implements IDBDatasetStatement
• Fixed : AV when setting TXDataset.Database property to a TGenericDatabase without having is Connection property set.

v1.7

• New : Option for custom proxy configuration for Windows clients or automatic proxy detection on Windows 8.1 and later
• New : Delphi 10.2 Tokyo Support

v1.6

• Fixed : Memo parameter values not being sent correctly when using TDatasetProvider
• Fixed : Index out of bounds when using TXDataset as a dataset provider and dbGo (ADO) at RemoteDB server side

v1.5

• New : Support for IProviderSupport allows using RemoteDB dataset (TXDataset) as a dataset provider - for example, in a setup using TClientDataset + TDatasetProvider + TXDataset

v1.4

• New : Delphi 10.1 Berlin support

v1.3

• New : Design-time wizard to create new RemoteDB Server with a few clicks
• Fixed : Error when executing SQL statements with string literals containing quotes or double quotes.

v1.2.4

• New : Delphi 10 Seattle support

v1.2.3

• Fixed : Setting TRemoteDBDatabase.Connected to true at design-time was causing error at runtime

v1.2.2

• New : Support for Delphi XE8

v1.2.1

• Fixed : Client sending wrong data in memo fields with empty strings

v1.2.0.1

• Improved : Installer

v1.2

• New : TGenericDatabase component allows using TXDataset to connect to database servers directly in old client-server style
• New : Support for Advantage Database Server
• Improved : Server database objects lifetime: now objects expire right after timeout period has passed
• Improved : Client transactions now can get longer than timeout of server db objects, RemoteDB keeps server-side objects alive automatically
• Fixed : Wrong initial values when inserting a record using TXDataset in Delphi XE4 and up
• Fixed : Sporadic "CoInitialize not called" error in RemoteDB demo
• Fixed : Server issues when queries caused infinite deadlocks
• Fixed : Error with long-running queries that take longer than timeout of server db objects

v1.1.1

• New : Added Delphi XE7 support

v1.1

• New : TXDataset.Unidirectional property improves memory usage and performance when using dataset in forward-only (unidirectional) mode.
• New : TRemoteDBDatabase.Timeout property allows specifying lifetime of inactive database connections on server side.
• Improved : Server now returns a better error message if a transaction commit/rollback request fails.
• Fixed : Server instability in rare situations when connection/disconnection to database at server side raised errors.
• Fixed : Error when executing data modification SQL statements (Insert, Delete, Update) using Open method instead of Execute, when using SQL-Direct and some other specific components.