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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     FOC280 Error Message
Go
New
Search
Notify
Tools
Reply
  
FOC280 Error Message
 Login/Join
 
Member
posted
I have not been able to figure out a way to understand the errors that are returned when attempting to run a report in the Managed Reporting environment.
I am attempting to develop a new report and need some help interpreting the following error message:

0 ERROR AT OR NEAR LINE 24 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

Is there a place where these messages are documented?
 
Posts: 26 | Location: Little Rock, AR | Registered: October 29, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The comparison of computational with alpha members often occurs in a define or compute where you forget the format and the field defaults to integer:

For example:

COMPUTE ZYZ = ABC;
COMPUTE XYZ/A4 = 3;
If ABC is alpha the error is generated. Or in the second case you may or may not get an error depending on the version you are at.
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Thanks for the input. I have been able to narrow down the problem. I am wanting to create a report that will run for a particular date range. I have begin date and end date variables which the user will enter. The dates they enter will be compared to a date field on the table. Any suggestions as to how I can specify that my parameters are date fields?
 
Posts: 26 | Location: Little Rock, AR | Registered: October 29, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Here is how I run reports for a user specified date range. The user enters the start date and end date as text (e.g. 01/01/2005), and WebFocus adds the time information to compare it to a DateTime field in a SQL database.


WHERE ( CUST_CREATED GE DT(&startDate 00:00:00) ) AND ( CUST_CREATED LE DT(&endDate 23:59:59) );
 
Posts: 1 | Location: Cranston, RI | Registered: April 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
If you have WebFOCUS documentation (printed or CD), there should be an appendix at the end of the Creating Reports manual (Appendix B in mine) that will either provide descriptions for all erroe messages or tell you how to issue a command to find the text for a specific focus error.

Here is an excerpt from my manual:

To display the text and explanation for any message, issue the following query command in
a stored procedure
? n
where:
n
Is the message number.

The message number and text displays, along with a detailed explanation of the message
(if one exists). For example, issuing the following command

? 210

displays the following:

(FOC210) THE DATA VALUE HAS A FORMAT ERROR:
An alphabetic character has been found where all numerical digits are
required.
 
Posts: 135 | Location: Portland, OR | Registered: March 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     FOC280 Error Message

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