mORMot Open Source

Ericshen

Member

Registered: 2017-02-25

Posts: 10

Json to DataSet is error, 0.0 is not a valid timestamp

hi, ab :

In MSSQL 2012 Record date looks like  :

userid    nick        classid    FName    edate
3113281    3113281    1    test           2017-03-31 14:33:40.843

I used  Execute funtion  Got  the RawJSON data  from MSSQL  , and then I uesed JSONToDataSet for json to Dataset is error.  return error  :  0.0 is not a valid timestamp

var
   IR: IRemoteSQL;
   i : integer;
   ts,te: Long;
begin
  ts :=   GetTickCount ;
  if Assigned(Client) then
  begin
    if Client.Services['RemoteSQL'].Get(IR) then
    begin
      ds1.DataSet := JSONToDataSet(self,(IR.Execute(aSQL,True,False)));  //aSQL :='select * from table' 
    end;
  end;
  te :=GetTickCount;

  Memo1.Lines.Add('use time(s):'+inttostr(te - ts)) ;

This was developed with Delphi 10 berlin on Windows  10

thanks !

Junior/RO

Member

Registered: 2011-05-13

Posts: 210

Re: Json to DataSet is error, 0.0 is not a valid timestamp

These 'not a valid timestamp' erros are preventing me of updating mORMot. The last good commit, that don't give this errors, was 938ae78a5b5ecb464e8e0d7d8544ba3a9e09eb38 in january, 23.