Error Unknown Type : 14

Comments

• mseehuber

  October 2005 edited 9:21PM

  No Answer is also an answer.
  
  Maybe is this an big Bug or does anyone use an TBetterAODDataset or TADODataset resultset with an TFrxDBDataSet without any Problems.
  
  
  
  
• mseehuber

  October 2005 edited 9:21PM

  To check, if this is an bug, i used an kbmemtable and copied all record into it.
  
  And, which surprise, with this memory table the report works. So there is definitly an bug with TADODatasets and retrieving values from fields.
• mseehuber

  October 2005 edited 9:21PM

  Problem located :
  
  Unit : frxClass.pas
  
  function TfrxReport.DoGetValue(const Expr: String; var Value: Variant): Boolean;
  ...
  GetDataSetAndField(Expr, ds, fld);
  if (ds <> nil) and (fld <> '') then
  begin
  Value := ds.Value[fld];
  if FEngineOptions.ConvertNulls and (Value = Null) then
  ...
  ...
  
  
  if FEngineOptions.ConvertNulls and (Value = Null) then
  raises sometimes in the ( Value = Null ) condition an Exception.
  
  On changing this to
  if FEngineOptions.ConvertNulls and ( VarType( Value ) = 0 ) then
  
  all workes fine, all all data are shown.
  
  
  
  
  
• DiGi

  October 2005 edited 9:21PM

  Value = Null is bad, should be
  
  VarIsNull(Value)