Yes that is so. IB does however allow triggers to be created but
they dont fire. I created all 6 posible triggers. It would be
nice if FB told you on creation that you cant create a trigger
on a read-only table.

Thanks for the answers I learned something new.

Groete
Gerhardus

>
> I don't think you can have an updateable view that is based on an
> aggregation.
>
> regards,
> Helen
>

CREATE VIEW ITEMVIEW3
(
CODE,
QTYAVAILABLE,
BRANCHNAME

) AS
Select CODE, SUM(AMOUNT), BRANCH
FROM ITEMS
GROUP BY CODE, Branch