SQL breaking
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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