FNCDatagrid don't display correctly data with DislayFormat assigned (in TwebClientDataset)

WEB TMS WEB Core
1

Using TwebClientDataset with fields that have DisplayFormat ed EditFormat assigned (especially for currency fields), values displayed in FNCDatagrid ignore DisplayFormat settings.
Thanks

6

Hi,

TTMSFNCDataGrid uses pure data from the field, so it's possible to perform sorting, calculations and more. If you don't want this, you can use DisplayText by implementing the following event:

procedure TForm1.TMSFNCDataGridDatabaseAdapter1FieldToData(Sender: TObject;
  ACell: TTMSFNCDataGridCellCoord; AMasterField, AField: TField;
  var ACellValue: TTMSFNCDataGridCellValue; var Handled: Boolean);
begin
  ACellValue := AField.DisplayText;
  Handled := True;
end;

However, if you want to keep pure data and control formatting, you can implement this directly at grid level. you can read more about it here:

7

OK, Pieter,
I will try, Thanks