mORMot Open Source

畅雨

Member

Registered: 2013-10-24

Posts: 29

mssql server2012 + syndbfireDAC:If fieldtype is boolean then error : C

Test : mssql server2012 + syndbfireDAC : If fieldtype is boolean then error : Cannot access field 'Booleanfield' as type Integer

synDBDataset.pas   line  584

Replace
 ...
 if ColumnValueDBType=IsTLargeIntField then
          WR.Add(TLargeintField(ColumnAttr).AsLargeInt) else
           WR.Add(TField(ColumnAttr).AsInteger); ----this error
...
as 
...
 if ColumnValueDBType=IsTLargeIntField then
          WR.Add(TLargeintField(ColumnAttr).AsLargeInt) else
          begin 
             if TField(ColumnAttr).DataType =ftBoolean then
              WR.Add(ord(TField(ColumnAttr).AsBoolean))   -------ok!
            else
              WR.Add(TField(ColumnAttr).AsInteger);
          end;
...

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: mssql server2012 + syndbfireDAC:If fieldtype is boolean then error : C

Should be fixed now by http://synopse.info/fossil/info/dc025529d6

Thanks for the report.