Difference between revisions of "Visimage FAQ"
| Line 11: | Line 11: | ||
:*The value in the original X10 field is: OX5 2LD | :*The value in the original X10 field is: OX5 2LD | ||
:*The expression is: #add-own-zip = ADDRESS-INFO.ZIP | :*The expression is: #add-own-zip = ADDRESS-INFO.ZIP | ||
| − | :*In this example, the convert error is being caused by a foreign zip-code. Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''. | + | :*In this example, the convert error is being caused by a foreign zip-code. |
| + | :*Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''. | ||
<pre> | <pre> | ||
Error #138 in list execution: | Error #138 in list execution: | ||
| Line 19: | Line 20: | ||
:*Again we see that a Character value (X2) is being converted to a numeric (P20). | :*Again we see that a Character value (X2) is being converted to a numeric (P20). | ||
:*The value that cannot be converted to a number is: TX | :*The value that cannot be converted to a number is: TX | ||
| − | :*This error was caused by attempting to total the MEMBER-FILE.STATE column. Remove the Total option to clear the error. | + | :*This error was caused by attempting to total the MEMBER-FILE.STATE column. |
| + | :*Remove the Total option to clear the error. | ||
<pre> | <pre> | ||
Error #138 in selection: | Error #138 in selection: | ||
| Line 25: | Line 27: | ||
</pre> | </pre> | ||
*In this example, Visimage3 is trying to convert an X2 value "JT" into an numeric (I2). | *In this example, Visimage3 is trying to convert an X2 value "JT" into an numeric (I2). | ||
| − | *This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT". (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.) Change ACCOUNT to ASSOC-CODE to clear the error. | + | :*This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT". (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.) |
| + | :*Change ACCOUNT to ASSOC-CODE to clear the error. | ||
Revision as of 17:24, 6 June 2023
Visimage3 Frequently Asked Questions
Convert Error
Error #138 in list execution: Convert Error - Invalid Digit:(X10 -> P20) OX5 2LD reg:#add-own-zip exp:ADDRESS-INFO.ZIP
- The error message contains useful information to help isolate the issue:
- Visimage3 is trying to convert a character, length 10, value (X10) to a numeric (P20) value.
- The value in the original X10 field is: OX5 2LD
- The expression is: #add-own-zip = ADDRESS-INFO.ZIP
- In this example, the convert error is being caused by a foreign zip-code.
- Change the variable definition for ADD-OWN-ZIP from Numeric to Character, length 10.
Error #138 in list execution: Convert Error - Invalid Digit:(X2 -> P20) TX
- In this example, there is less information displayed. That indicates, that this error does not involve a variable compute statement.
- Again we see that a Character value (X2) is being converted to a numeric (P20).
- The value that cannot be converted to a number is: TX
- This error was caused by attempting to total the MEMBER-FILE.STATE column.
- Remove the Total option to clear the error.
Error #138 in selection: Convert Error - Invalid Digit:(X2 -> I2) "JT"
- In this example, Visimage3 is trying to convert an X2 value "JT" into an numeric (I2).
- This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT". (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.)
- Change ACCOUNT to ASSOC-CODE to clear the error.
