RB_* Tables
Hi,
I have a database question which is more of a deployment issuer than
anything else:
The RB_Field, RB_Table and RB_Join tables can be populated nicely with
insert scripts
but what happens when I want to change the underlying datamodel?
Do you all write insert, update & delete scripts to keep the RB_* Tables in
sync
with the datamodel???
I use Oracle and what is going thru my head is why not create a view that
selects
from ALL_Tables (for RB_Table) and from All_Tab_Columns (for RB_Field).
That way my ReportBuilder information is always up to date!
Ideas??? How can I do RB_Join?
Thanx,
Andrew
(apwhite@hotmail.com)
I have a database question which is more of a deployment issuer than
anything else:
The RB_Field, RB_Table and RB_Join tables can be populated nicely with
insert scripts
but what happens when I want to change the underlying datamodel?
Do you all write insert, update & delete scripts to keep the RB_* Tables in
sync
with the datamodel???
I use Oracle and what is going thru my head is why not create a view that
selects
from ALL_Tables (for RB_Table) and from All_Tab_Columns (for RB_Field).
That way my ReportBuilder information is always up to date!
Ideas??? How can I do RB_Join?
Thanx,
Andrew
(apwhite@hotmail.com)
This discussion has been closed.
Comments
connect them to a TDataset descendent data sources, they are happy. The
data model shouldn't change, since the RB components won't change what they
need from the datapipelines. What may change, is if you decide to add a
field to the Items table (templates), in order to store extra info for each
report.
Cheers,
Jim Bennett
Digital Metaphors Corp
http://www.digital-metaphors.com
info@digital-metaphors.com