> 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?

According to the following tracker item, yes.

http://tracker.firebirdsql.org/browse/CORE-3141



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/