Focal Point
Error Messages

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4871097331

August 25, 2004, 01:10 PM
bsneln
Error Messages
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

Thanks!
Barb
August 25, 2004, 01:51 PM
<Pietro De Santis>
The errors are possible due to Date/Time fields or Text (not alpha) fields. Check/recreate your Masters.
August 31, 2004, 01:41 PM
GCohen
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.