Hello, Thomas Steinmaurer,

Thanks for your information. I thought it already fixed on final version but it's not.

======= At 2010-10-07, 05:43:24 you wrote: =======

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

>

= = = = = = = = = = = = = = = = = = = =



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