🚀 go-pugleaf

U�ytkownik "Arjan de Haan" <2x nospam nospam adwhaan AT hotpop.com> napisa� 
w wiadomo�ci news:473a11f4@newsgroups.borland.com...
> Hi.
>
> We have an existing installation of IB Server 6 which I was updating to 
> incorporate some new views. When testing I ran across the following 
> problem.
> I have a view, which results depend on the existing of matching data in 
> another view, like this:
>
> SELECT Locaties.LocatieOID, Locaties.Verwijderd, Locaties.Naam, 
> Locaties.Tellergebruik, Locaties.Tellersaan, Klanten.KlantOID, 
> Klanten.Naam, Adressen.Plaats
> FROM ((Locaties INNER JOIN Klanten ON Locaties.KlantOID = 
> Klanten.KlantOID)
>                INNER JOIN Adressen ON Locaties.AdresOID = 
> Adressen.AdresOID)
> WHERE
>    (EXISTS (SELECT TijdelijkOID FROM Tijdelijk
>             WHERE (Tijdelijk.LocatieOID = Locaties.LocatieOID)))
>    OR
>    (EXISTS (SELECT LOCATIEOID FROM VIEWLOCAUTMCOUNT
>             WHERE VIEWLOCAUTMCOUNT.LocatieOID = Locaties.LocatieOID))
>
> This query works, as long as i remove the EXISTS(....) on the 
> ViewLocAutmCount from the query. If it is used, even trying to explain the 
> query (retrieving the plan) crashes IB!!
> To explain the query (or what I'm trying to do): I need locations, but 
> only those that have either a reference from another table (Tijdelijk), or 
> where equipment is placed (ViewLocAutmCount, which lists the number of 
> appliances placed at a location).
>
> Anybody can show me what I'm doing wrong? Can't IB 6 handle referencing 
> views from within views??
> Tx.
> ...Arjan...
>

this is so old version of interbase - upgrade it
or use Firebird

Karol Bieniaszewski