Migration dbExpress to Firedac

Question

I’m migrating a system dbExpress to the Firedac, the system is in three layers (multtier), changed the components on the server side of SQLConnection for FDConnection, and the SQLDataset for FDQuery, on the customer side the components continue to be the ClientDataset, but I saw that in FDQuery the fields of the type INT32 are read from the database (Mysql) as TLongWordFields and not TIntegerFields, I have about a hundred ClientDatasets with all fields of the type TIntegerField, I have to make the change in all or is there another way around it?

Obs.: The fields auto increment are read in the Firedac as TFDAutoIncField and not TIntegerField but there is no problem of incompatibility.

Answer 1

On the server side, on the components you switched to FDQuery, you do not need to load the fields. Do a test, leave only the SQL query on FDQuery, on the client side add a ClientDataset "new, do not reuse or copy is paste", then load the fields in the ClientDataset and see if the fields are equal.