At 01:56 PM 30-01-01 +0100, you wrote:

>Gerald,
>I think you mean
> SELECT A, B, A||B as C
>
>I thought he was adding numbers...
>
>Set

No, this was his complaint:

>> If C is DbText value isn't displayed in ReportBuilder,
>> but if C is DbCalc value of C is displayed.

...reinforcing that '+' works for adding two numbers together but not for
concatenating text.

:))

>At 12:44 30.01.2001 -0000, you wrote:
> >Have you tried:
> >SELECT A, B, A|B as C
> >I remember reading somewhere that IB doesn't like to add strings. It
> >needs to concatinate them.
> >
> >Gerald S. Brown
> >
> >--- In IBObjects@y..., "Jaroslav KULHEIM" <kulheim@f...> wrote:
> >> Hi all,
> >>
> >> SELECT A, B, A+B as C FROM anytable
> >>
> >> If C is DbText value isn't displayed in ReportBuilder,
> >> but if C is DbCalc value of C is displayed.
> >>
> >> Can you test this simple query - don't know if it's IBO, IBO
> >pipeline or RB
> >> related problem.
> >>
> >> RB5.0, IBO3.6.A, D4
> >>
> >> thank you for your answer,
> >>
> >> Jaroslav Kulheim
> >> kulheim@f...
> >
> >
> >
> >
> >
> >
>
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________