Integration with 3rd Party Products Questions (FireDAC)

From RAD Studio
Jump to: navigation, search

Go Up to FAQ (FireDAC)

This topic contains a list of questions and answers related to integration with 3rd party products.

Q1: Is there a FastReport add-on (or other) and is it supported officially?

A: Please contact FastReport.

Q2: Unidirectional query and DevExpress grid. With Query.FetchOptions.Unidirectional = True, TDataset(Query) is not set as Unidirectional (TDataset(Qurey).IsUnidirectional = False). Because of that there are problems with DevExpress grid

A: The problem is that setting TDataset(Query).IsUnidirectional to True will break TFDDataSet functionality. At the moment, we do not have a correct solution and need additional investigation. We suggest to modify DevEx sources to avoid this issue. For that:

  • Open ExpressDataController\Sources\cxDBData.pas unit:
  • Find TcxDBDataProvider.IsUniDirectional and replace it with:
function TcxDBDataProvider.IsUniDirectional: Boolean;
begin
  if Assigned(DataSet) then begin
  {$IFDEF DELPHI6}
    if DataSet.IsUniDirectional then
      Result := True
    else
  {$ENDIF}
      if DataSet is TFDRdbmsDataSet then
        Result := TFDRdbmsDataSet(DataSet).FetchOptions.Unidirectional
      else
        Result := False;
  end
  else
    Result := False;
end;