Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

SQL breaking

edited October 2009 in General
I recently upgraded from Delphi2006 to Delphi 2007 (for Win32) and upgraded
to ReportBuilder Standard 11.06. All the reports run fine. I just needed to
change the edit mask of a datafield in one report. After I changed the mask,
the report incorrectly showed no data. I restored the backup units and the
report ran fine again. I then went back into the code, opened the TppReport,
and clicked on a TppDBText field without changing anything. After closing
the TppReport I ran the report the again the report showed no data. I also
saw that the query had returned no results. I restored the backup units
again and went back to the code, opened the TppReport and clicked on a
TppLabel field without changing anything. This time the report ran
correctly.

So whenever I access a DB field on the reort, the query seems to break. Any
help would be greatly appreciated.

Stan Walker

Comments

  • edited October 2009
    Hi Stan,

    Which version of ReportBuilder did you upgrade from? What
    database/connectivity are you currently using? Are you able to create a
    similar report from scratch without any errors or is this something that
    occurs with every report?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2009
    I upgraded from ReportBuilder 10.07. I am using Interbase 7.5 with a
    TIBOQuery (IBObjects 4.8), a TDataSource, a TppDBPipeline, and a TppReport.

    After further testing of other reports, I can only break the one report
    (although I broke two before). I will create the report again from scratch
    and see if it works. If you don't hear back from me, it must have worked.

    Nico, thanks for the quick response.

    Stan





This discussion has been closed.