mORMot Open Source

dottor_jeckill

Member

Registered: 2017-11-22

Posts: 5

TSynSQLTableDataSet and TDateTime bug?

Hello,

i have a TSQLRecord derived class with a TDateTime field, like this:

Type 
  TTest = class(TSQLRecord)
     private
         fTestName : string;
         fTestDate : TDateTime;

     published
         property TestName : string read fTestName write fTestName;
         property TestDate  : TDateTime read fTestDate write fTestDate;
end;

and i need to trasform it in a DataSet for a report. But before i want to see it in a Grid.

If i convert this table on a TSynSQLTableDataSet, using the MormotVCL function JSONToDataSet, or using the creators of the class, i have an error on showing values on the grid becouse che TDateTime field (TestDate) have a bad format (it contains a 0.45556 number for example..).

If i convert this table in a TClientDataSet, with the MormotMidasVCL function JSONToClientDataSet i have no problem and the grid is perfect.

Someon know why this happens? Is a bug?

Thanks.