RB_ITEM - How to load the RB_ITEM table from an insert script?
Greetings All,
Delphi 5.1
RB 7.03
Interbase 6.0.1.6
We are just getting to the point of starting to create reports for our
project. We have decided to use the TppReportExplorer component thus
allowing our end users to create and use their own reports. However, we
also will create several of our own pre-defined reports for inclusion with
our product both before and after the product ships.
I have developed our first pre-defined end user report at runtime and saved
it to the RB_ITEM table. So far so good.
Our Interbase Database is still undergoing development and from time to time
we will have a new GDB (Database) sent to us by our database developer.
This database is of course void of any data, so we use insert scripts to
pre-populate some of the tables. We are using Database Workbench to create
the insert scripts for this purpose. The problem lies in the fact that when
it is time to insert data in the RB_ITEM table using this insert script, it
fails when trying to insert data into the TEMPLATE field. Is this because
you cannot use insert script to insert BLOB data? Anyway, this is a little
disappointing to us, as when the need to send out new pre-defined reports
comes up, we were going to create them at runtime in our app, them export
the one record to an insert script and send it to the end user.
So my question is, how do others pre-populate this table with data including
the template data? Or, are we going to have to store rtm files outside of
the RB_ITEM tables? If so, will the ReportExplorer allow us to do this?
Any helpful tips appreciated.
--
Michael Tuttle
Software Technologies, Inc.
Topeka, KS
Delphi 5.1
RB 7.03
Interbase 6.0.1.6
We are just getting to the point of starting to create reports for our
project. We have decided to use the TppReportExplorer component thus
allowing our end users to create and use their own reports. However, we
also will create several of our own pre-defined reports for inclusion with
our product both before and after the product ships.
I have developed our first pre-defined end user report at runtime and saved
it to the RB_ITEM table. So far so good.
Our Interbase Database is still undergoing development and from time to time
we will have a new GDB (Database) sent to us by our database developer.
This database is of course void of any data, so we use insert scripts to
pre-populate some of the tables. We are using Database Workbench to create
the insert scripts for this purpose. The problem lies in the fact that when
it is time to insert data in the RB_ITEM table using this insert script, it
fails when trying to insert data into the TEMPLATE field. Is this because
you cannot use insert script to insert BLOB data? Anyway, this is a little
disappointing to us, as when the need to send out new pre-defined reports
comes up, we were going to create them at runtime in our app, them export
the one record to an insert script and send it to the end user.
So my question is, how do others pre-populate this table with data including
the template data? Or, are we going to have to store rtm files outside of
the RB_ITEM tables? If so, will the ReportExplorer allow us to do this?
Any helpful tips appreciated.
--
Michael Tuttle
Software Technologies, Inc.
Topeka, KS
This discussion has been closed.
Comments
Perhaps ask someone in the Borland newsgroups and/or search Google Groups in
regards to whether blob data can be included in SQL scripts.
Alernatives would be
1. Ship a database table (essentially an rbItem table that contains the
model reports) and write a utility to load the master reports into the
customer's database.
2. Ship .rtm's (yes from the ReportDesigner you can load from the report
explorer and save to file OR load from file and then save to the database.
To enable this option you need to set Designer.AllowSaveToFile to true.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com