Ann W. Harrison wrote:

>Ann W. Harrison wrote:
>
>
>>
>>
>>>Actually, NUMERIC is stored as smallint and DECIMAL as integer.
>>>
>>>
>
>I was wrong, Rick is right. For precision < 5 NUMERIC is a small int
>and DECIMAL is integer. Precisions between 5 and 9 both use integer,
>and precisions 10 and above both use int64.
>
>Beats me why. Each of them will happily exceed the precision specified.
>
>
>
>

Isn't this a bug???? NUMERIC should never store more precision. No
wonder SUM never
works.

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

--
Thomas Miller
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
https://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus