mORMot Open Source

songshuang

Member

From: changzhou,jiangsu,china

Registered: 2018-08-09

Posts: 22

real field type set to null

Hi ab,
   TDbEdit(Real Field) <--> TSqlDBClientDataSet <--> TSQLDBSQLite3ConnectionProperties <--> SQLITE3
   The Record real field be setted to null when dbEdit be setted empty, this is string 'null' not NULL.
   the code file: mormot.db.sql
     line  5948  ： with TVarData(Data) do
                         case VType of
                             varEmpty,varNull:
                                 .....
   then all is ok.

songshuang

Member

From: changzhou,jiangsu,china

Registered: 2018-08-09

Posts: 22

Re: real field type set to null

make a correction, TUniDBNumberEdit ,not TDbedit

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,007

Website

Re: real field type set to null

Makes sense.

Please try with
https://github.com/synopse/mORMot2/commit/f21d5dcc8