Kevin,

your way is okay, but if I make it like you, I must change the code
of the program, if I change something in the table structure.

Best Martin

--- In IBObjects@egroups.com, Kevin Everhart <tashi@f...> wrote:
> I do it a bit different. I have multiple Queries which can be
multiple
> tables in one database or multiple tables in multiple databases.
>
> The results of the Queries are fed into an Array, then I create a
comma
> delimited txt file with the Array. Then assign the TppReport a
> TppTextPipeline using the built txt file.
>
> Works like a champ. Some of my reports have to run as many as 9
Queries to
> get all the data needed for the report.
>
> I could send you an example if you like.
>
> Hope this helps
> Kevin
>
> wes@l... wrote:
>
> > Martin,
> >
> > >How can I connect to 2 dbs?
> >
> > I'm assuming that, by 2dbs, you mean two tables (or queries). If
so,
> > all you need to do is provide a TppDataPipeline for each.
> >
> > Now, you can only assign one of them to the TppReport. But, in
the
> > report designer, you can assign any of the report controls to any
of
> > the pipelines.
> >
> > -----------------------------
> >
> > Wes Peterson
> > LexCraft Data Services
> > 916.944.4870
> > http://www.lexcraft.com
> > wes@l...
> >