Kbase P22023: Error 7498 when a character value is converted in to a integer datatype
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/10/2004 |
|
Status: Unverified
SYMPTOM(s):
Error 7498 when a character value is converted in to a integer datatype
Invalid number string (7498)
CAUSE:
When doing a conversion from a CHARACTER to an INTEGER datatype, the
character value needs to be a digit.
FIX:
Make sure your CHARACTER data is convertible to an INTEGER datatype.
Some examples of queries that will give this error are:
-- SELECT * FROM PUB.TableA WHERE 'FieldA-B' = 1
Use double-quotes instead of single-quotes.
-- SELECT NULLIF("FieldA-B", '?') FROM PUB.TableA
FieldA-B is using datatype INTEGER. The value "?" is not
convertible to an INTEGER.
-- SELECT Custnum*TO_NUMBER('100A') FROM PUB.CUSTOMER
100A can not be converted to an INTEGER.
References to Written Documentation:
Progress SQL-92 Guide and Reference