Subject Re: [ib-support] Please help. View is empty, but the same SELECT works!
Author Svein Erling Tysvaer
Oh, good, now it is easier to ask questions. Is Bank and AccountNo declared
as varchar or char or does any of them happen to be integer or even blob?


>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