That's it, Thanks Set, Claudio...

Nico
-----Oorspronkelijk bericht-----
Van: Claudio Valderrama C. [mailto:cvalde@...]
Verzonden: woensdag 4 april 2001 10:40
Aan: IBObjects@yahoogroups.com
Onderwerp: RE: To SET [IBO] Slow query question

> -----Original Message-----
> From: Nico Callewaert [mailto:ncw@...]
> Sent: Miércoles 4 de Abril de 2001 4:24
>
> I have
> a error message 'Fieldname : not found'. I'm already looking 2 hours

at

> it, but couldn't solve it maybe you know something.
> Even this little piece of code is not working in a IB_Query,
> removing the A.
> in fornt of the fielnames doesn't help
>
> SELECT A.DealerNo, A.Country,
> (SELECT B.Name FROM Country B WHERE B.Code = A.Country)
> FROM Dealer A
> WHERE A.DealerNo = 123456

(SELECT B.Name FROM Country B WHERE B.Code = A.Country) AS COUNTRYNAME

This is actually a bug in IB. Jason could give the column an arbitrary
name,
maybe.

C.


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]