I think the problem is PRICE*PRICE*PRICE*PRICE is greater than maximum
allowed, try to use small values.

If you read the manual, the Numeric(n,m) will be stored as integer with the
decimal position, so the numeric(13,4) wil store 999.999.999,9999

If you need numbers greater than this, try to use Double, but be carefull with
float truncation.

Max

On Wednesday 12 November 2003 03:20 pm, Sandor Szollosi wrote:
> Hi folks,
>
> I have a table with a NUMERIC(13,4) field,
> and a simple query:
>
> SELECT PRICE*PRICE*PRICE*PRICE FROM MY_TABLE
>
> This SQL gets an error:
> "Integer overflow. The result of an integer operation caused the most
> significant bit of the result to carry."
>
> But this works well:
> SELECT PRICE*PRICE*PRICE FROM MY_TABLE
>
> (PRICE=100 now, and one record exists in the table)
> Do you know this problem?
>
> Sandor
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.