Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Error Messages
 Login/Join
 
Member
posted
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
 
Posts: 4 | Registered: August 24, 2004Reply With QuoteReport This Post
<Pietro De Santis>
posted
The errors are possible due to Date/Time fields or Text (not alpha) fields. Check/recreate your Masters.
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.