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

RB_* Tables

edited February 2002 in General
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)

Comments

  • edited February 2002
    RB components rely on datapipelines to get the data. As long as you can
    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



This discussion has been closed.