At 12:44 PM 30-01-01 +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

but you need *two* pipe symbols, viz.

SELECT A, B, A||B as C

FYI, the double-pipe is the SQL standard concatenation
symbol. MSSQL/Access use '+' in an unsuccessful attempt to force BASIC
standards on the world :)) Paradox uses '+' for a different reason
entirely - the object language of the native Paradox IDE was built up from
a hotchpotch of the Pdox for DOS scripting language (which was derived long
before MSSQL or Access existed) from original ASCII Basic and structured
Pascal. Language archaeology. :))

H.

>--- 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
_______________________________________________________