Very clever indead.
By the time I make more than 2**31-1 $'s, I'll worry about it :)

Thank You

------------------------------------------------------------------------------------

----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, May 14, 2005 8:35 PM
Subject: Re: [firebird-support] FB1.5 Field Type Question


> Hans wrote:
>> variable total integer
>>
>> Using Dialect 1 .. select sum(total) as total -> Rave reports comes thru
>> as
>> a dtInteger, as expected.
>>
>> Using Dialect 3.. select sum(total) as total -> Rave reports fails on
>> 'expected fieldtype dtInteger but found dtInt64
>>
>
> Dialect 3 introduced BigInt - or variants - to handle binary values with
> a precision of more than 9 digits. The sum of a group of ints will, by
> default, be expressed as a BigInt because adding a group of numbers with
> values < 9 digits could easily result in a total that is > 9 digits. By
> casting the result back to an int, you run the risk of truncation, but
> avoid an error from the calling program.
>
>
> Regards,
>
>
> Ann
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>