dbExpress Migration to FireDAC

Question

dbExpress Migration to FireDAC

Navigation

#1 by (2 votes)

5

I'm migrating from a dbExpress system to FireDAC , the system is in three tiers >), I have changed components on the server side from SQLConnection to FDConnection , and SQLDataset to FDQuery , on the client side the components remain ClientDataset , however I saw that in FDQuery type INT32 are read from the database (MySQL ) as TLongWordFields and not TIntegerFields , I have about 100 ClientDatasets with all fields of type TIntegerField , I have to do the change in all or is there another way around this?

Note: The auto increment fields are read in FireDAC as TFDAutoIncField and not TIntegerField but no incompatibility problem occurs.

mysql delphi-xe6 firedac

asked by anonymous 13.10.2015 / 04:39

1 answer

Error entering data into bank, EF 6 How to query in ManyToMany tables?

score 2 · Answer 1

On the server side, on the components you have switched to FDQuery , you do not need to load the fields. Make a test, just leave the SQL query in FDQuery , on the client side add a ClientDataset "new, do not reuse or copy it's paste", after that load the fields in ClientDataset and see if the fields are the same.