How to clone UniConnection?

[sbokharis]

Hi,

We are developing a large system using UniDAC and MySQL. We have a main UniConnection in a data module. We set all properties at design time and some at run-time.

Read-only and system specific queries are handled in main connection. In all other forms, we make a clone of main UniConnection which is totally independent. Handle its inserts, updates, deletes and transactions separately on each form.
Currently, we do individual property assignment of non-default properties of main UniConnection in cloned connection. We know this is not an elegant way.

We have used AssignConnect method but it shares the same handle as mentioned in the documentation.

My question is this, what is the best way to clone a UniConnection?

Using Delphi 10.1 Update2, UniDAC 6.4.16 Pro

Regards

[ViktorV]

To solve the issue, you can assign the TUniConnection.ConnectString property to the new connection.