can you try these without the cast
and with just a where instead of join
to see what happens
create view vDeps2(DepID, Descr) as
select d.DepID, d.Bank||' '||d.AccountNo Descr
from DepRights r, departments d where r.DepID = d.DepID

and
select d.DepID, d.Bank||' '||d.AccountNo Descr
from DepRights r, departments d where r.DepID = d.DepID


-----Original Message-----
From: Andrew Guts [mailto:andr@...]
Sent: Monday, 16 September 2002 22:37
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Please help. View is empty, but the same SELECT
works!


Why SUM() is not a singleton? Do not pay attention on subselects. This
simplified version have the same problem with view:

select d.DepID,
cast(d.Bank||' '||d.AccountNo as varchar(64)) as Descr
from DepRights r
inner join departments d on r.DepID = d.DepID
_________________
12 rows

create view vDeps1 (DepID, Descr) as
select d.DepID,
cast(d.Bank||' '||d.AccountNo as varchar(64)) as Descr
from DepRights r
inner join departments d on r.DepID = d.DepID;

select * from vDeps1
________________
0 rows




Alan McDonald wrote:

>TotalIn and TotalOut are not singleton result sets are they...?
>That troubles me
>
>

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



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



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