At 12:11 PM 18/03/2005 +0000, you wrote:

>Sorry, did not find the correct recipe in Helen's book for this one:
>
>How do I use information from different databases in on Stored Procedure?

That recipe will be in a different book, about a different database engine...

>I know that I cannot join them, I just within a loop want to fill the
>row-buffer with data from different sources like this:
>
>if (:statusvariable = '01') then
>begin
> select
> [Database1].table_a.anyfield
> from
> [Database1].table_a
> where :IDvariable = 'thisID';
>end
>if (:statusvariable = '02') then
>begin
> select
> [Database2].table_b.anyfield
> from
> [Database2].table_b
> where :IDvariable = 'thisID';
>end
>
>What is the correct syntax to use 2 databases in 1 procedure?

It's not supported.

./hb