ADOQuery and SUM

edited 1:58PM in FastReport VCL 5
Does the SUM function for ADOQuery work? For FIB is ok. For
ADOQuery always receives zero

Comments

  • gpigpi
    edited 1:58PM
    Yes, it works OK. See FR Demo as a sample
  • edited 1:58PM
    > ADO not working[img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> other database (IBX,FIB etc) it's ok[/img]
  • gpigpi
    edited 1:58PM
    See report template for FRDemo (FRDemo uses ADO) in the attach
  • edited 1:58PM
    Such a scenario: simple application, in the datamodule adds ADOConnection. On the main form - frxADOComponents and set the default database. In my report, I use ADOQuery, which writes a query to the database. In that case, SUM does not work. I can not do as it is in the example. Someone met this? For frxFIB components, frxIBX works fine.
  • gpigpi
    edited 1:58PM
    Create small demo project with problem based on standart Delphi's components an FR Demo demo.mdb database and attach it here
  • edited 1:58PM
    solved. Releasing all FastReport components, recompile and re-add has helped. Maybe somewhere "typed" some error. Thanks
    >

Leave a Comment