TMSFNCDataGrid Errors

Could you please test the following:
Open the demo file \Products\tms.fnc.uipack\Demos\VCL\DataGrid\Advanced\Filter Row. Build it in debug mode and run it with debugger. I'm getting many errors. "Ungültiger Datums-String..." I'm using Delphi 11.2.

Can you please provide some more details, stack trace or screenshots of the error?

I am using tms.fnc.uipack version 6.9.0.1

Thanks for the additional information. For some reason, it thinks the last column is date time, which is strange. I'll further investigate.

Thanks for the quick reply.
I'm not sure if it's related, but in another project I'm also getting these error messages, and the datetimepicker for the column filter is automatically set to 30.12.1899.

The issue will be fixed in the next release of TMS FNC UI Pack. The IDE is throwing exceptions instead of gracefully handling incorrect ISO 8601 formatted strings. in Delphi 12 and up this is fixed. You should be able to run the application in release mode fine.

Okay, could you take another look at the problem with the default date in the filter? In the demo, I added a date value to the Cars.csv file and the line
TMSFNCDataGrid1.Cells[9,0] := 'Date';
in the FormCreate event. Even here, the column filter defaults to "30.12.1899". Where does this value come from, and how can I change it? The CSV file always shows the value "12.12.2024". I run this Demo in Release mode.

Hi,

this value comes from the date-picker control inside the filter editor. We set this value to 0. However we'll change this and just create the date-picker which changes the date to Now. If you want to customize this you can use

procedure TForm1.TMSFNCDataGrid1AfterCreateFilterEditor(Sender: TObject;
  ACell: TTMSFNCDataGridCellCoord; AEditor: TTMSFNCDataGridCellControl);
var
  e: TTMSFNCDataGridCellControl;
begin
  e := (AEditor as TTMSFNCDataGridFilterPanel).Editor;
  if Assigned(e) and (e is TTMSFNCDataGridDatePicker) then
    (e as TTMSFNCDataGridDatePicker).Date := Now;
end;

OK, that works. But after starting the program, the value is grayed out.


When you hover over it with the mouse, the value is displayed.

Filtering via the DateTimePicker works. However, when I select a value using the filter button, the value "30.12.1899" reappears in the DateTimePicker.

For your information: If the filter in the DateTimePicker is activated, the value will only change to 30.12.1899 when a different filter value is selected in the filter button menu. If the filter in the DateTimePicker is not activated, the value in the DateTimePicker will change to 30.12.1899 immediately when the filter button is clicked.

Thanks for the feedback! We'll make some additional improvements to fix this behavior. Fixes will be available in the next release.

Thank you for the quick processing.

1 Like