----- Original Message -----
From: <bobzirbel@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 21, 2001 10:46 AM
Subject: [IBO] Re: Cannot prepare a query


> Marcel
>
> Try this:
>
> 'Select a.MEMBERID, a.CHNAME || a.ENGNAME AS FULLNAME from MEMBSERS a'
>
> The concatenated fields need to be assigned a single name.
>
> Regards
>
> Bob
>
>
> --- In IBObjects@y..., "Marcel" <ibobjects@m...> wrote:
> > Goodmorning,
> >
> > I am using D5ENT and IBO4.2Eb
> >
> > I key in this query in query editor 'Select a.MEMBERID, a.CHNAME ||
> > a.ENGNAME from MEMBSERS a'
> > This statement cannot prepare with Field not found error.
> > But this query can prepare 'Select a.MEMBERID, a.CHNAME, a.ENGNAME
> from
> > MEMBERS a'
> >
> > Could anyone give me some advice?
> > Thanks
> > Marcel
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>