Subject | Select problem --- numeric (13,4) field --- |
---|---|
Author | Sandor Szollosi |
Post date | 2003-11-12T15:20:39Z |
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
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