The code sample below shows one way to retrieve records from an MSSql Server
in a background thread using FireDAC. Tested for Delphi 10 Seattle
As written:
The thread retrieves data using its own TFDConnection and TFDQuery and transfers
the data to the form's FDQuery in a call to Sychronize...
