Getting these error messages in several procedures since I set the sqlengine to sqlora. Any suggestions?
0 ERROR AT OR NEAR LINE 27 IN PROCEDURE billing_detl_rept
(FOC015) THE TEST VALUE IS LONGER THAN THE FIELD FORMAT LENGTH: 02/01/2004
0 ERROR AT OR NEAR LINE 27 IN PROCEDURE ���FOCEXEC *
(FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
|<Pietro De Santis>|
The errors are possible due to Date/Time fields or Text (not alpha) fields. Check/recreate your Masters.
Generally we should examine each error message alone.
The first one you have says that you have a data field that is defined as being smaller than the test value you supplied, eg the field has a format of A8 and you tried to test a value with 9 or more characters.
The second error message says that in some WHERE statement you are testing an Alpha field against a numeric field. This might be because you didn't enclose the alpha test value in single quotes. Or a numeric field has an alpha test..
eg WHERE COST EQ 'ABC' and COST is numeric.
|Powered by Social Strata|