Difference between revisions of "Visimage FAQ"

From Vital Soft Wiki
Jump to: navigation, search
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.