ToClientDataSet not support DECIMAL Fields

xchinjo · 2017-08-29 11:52:45

when use ToClientDataSet from mORMotMidasVCL.pas TSQLFieldType is not support DECIMAL fields

ab · 2017-08-29 12:11:44

Do you mean "decimal" in which context?
Our code handles sftCurrency kind of content, which holds number with fixed decimals.
If your TSQLTable has the expected type information for the columns, as input to ToClientDataSet function, there is no problem.

It is not clear what you meant here...

xchinjo · 2017-08-29 12:15:56

GetDBFieldDef result sftUnknown

xchinjo · 2017-08-29 12:18:44

My Database Field Type is "Decimal(18,4)"

ab wrote:

Do you mean "decimal" in which context?
Our code handles sftCurrency kind of content, which holds number with fixed decimals.
If your TSQLTable has the expected type information for the columns, as input to ToClientDataSet function, there is no problem.
It is not clear what you meant here...

xchinjo · 2017-08-29 12:21:38

this my function

var
  Cds:TClientDataSet;
  i:integer;
begin
  Cds:=TClientDataSet.Create(nil);
  try
    JSONToClientDataSet(cds,GetDataSet(strSQL),nil,cdsNew,false);
    Result := cds.data;
  finally
    Cds.Free;
  end;
end;

ab · 2017-08-29 13:09:49

Your GetDataSet function is not setting the corresponding fields types.
Could you use the overloaded JSONToClientDataSet() function, and include the TSQLRecordClass information?

xchinjo · 2017-08-30 04:44:00

@ab, Thank you i will send small sample to you later.

mORMot Open Source

#1 2017-08-29 11:52:45

ToClientDataSet not support DECIMAL Fields

#2 2017-08-29 12:11:44

Re: ToClientDataSet not support DECIMAL Fields

#3 2017-08-29 12:15:56

Re: ToClientDataSet not support DECIMAL Fields

#4 2017-08-29 12:18:44

Re: ToClientDataSet not support DECIMAL Fields

#5 2017-08-29 12:21:38

Re: ToClientDataSet not support DECIMAL Fields

#6 2017-08-29 13:09:49

Re: ToClientDataSet not support DECIMAL Fields

#7 2017-08-30 04:44:00

Re: ToClientDataSet not support DECIMAL Fields

Board footer