Hello, firebird-support,

I'm trying to make view something like this:

CREATE VIEW ViewSample(
ID,
NumberTrans,
DateTrans,
AccCode,
Amount)
AS
select
id, NumberTrans, DateTransaction, AccCdoe, cast(amount as numeric(18,4))
from
( <<derived table>>
)
where amount <>0;

That view working well on Firebird 2.1.1 but return null value at Field Amount on almost record on Firebird 2.5. Is this bug?

Best regards

Andi Wangsadijaya
And1_Wangsadijaya@...
2010-10-07


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