Data Types

[bsneln]

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

I know that the data types don't agree somewhere, but can someone give me some detailed instructions on how to fix this?

Thanks!
bsneln

 

[FOCMAN]

Can you display your procedure around line 27? Are you issuing SQL in your procedure? By settting engine to SQLORA your SQL out of the back end has to meet ORACLE syntax. If you leave SQLENGINE alone WebFOCUS takes care of the proper ORACLE syntax. I do not use SQLENGINE seetings unless using SQL Pass thru.

 

[bsneln]

Line 27 starts with the where statement:

SET NODATA = ' ';
JOIN STAFF.USERID IN STAFF TO ALL PROJECT_TIME.USERID IN PROJECT_TIME AS J1
JOIN PROJECT_TIME.DIVISION IN STAFF TO ALL DIVISIONS.DIVISION IN DIVISIONS AS J2
DEFINE FILE STAFF
EMPLOYEE/A50=STAFF.FNAME|' '| STAFF.LNAME;
END
TABLE FILE STAFF
PRINT
'STAFF.EMPLOYEE'
'PROJECT_TIME.TIME'
'PROJECT_TIME.COMMENTS'
BY
'DIVISIONS.DIV_NAME' AS 'DIVISION'
BY
'PROJECT_TIME.TIMEDATE' AS 'DATE'
BY
'STAFF.USERID' NOPRINT
HEADING
"Billing Detail Report"
" "
" "
"02/01/2004 to 02/27/2004"
FOOTING
"Prepared on <+0>Aug 31, 2004 <+0> "
WHERE ( PROJECT_TIME.TIMEDATE GE '02/01/2004' ) AND ( PROJECT_TIME.TIMEDATE LE '02/27/2004' ) AND ( STAFF.DIVISION EQ 'MIS' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET WEBVIEWER ON
ON TABLE SET HTMLCSS ON

We are getting these errors since I made a new procedure called launch_billing.fex. In this procedure, I set the sqlengine = sqlora as below:

RUN

SQL SET SERVER EDASERVE
SQL SET CONNECTION_ATTRIBUTES EDASERVE/WEBFOCUS/D73F51D2260392CA

SELECT A.USERID, A.TIMEDATE, A.DIVISION, A.PROJECT, A.TIME, F.DISPLAY, F.HOURS
FROM PROJECT_TIME A, HOURS_DISPLAY F
SQLOUT
PRINT *
END

Before I did the launch_billing procedure, we were getting these error messages:

(FOC1400) SQLCODE IS 942 (HEX: 000003AE)
(FOC1409) SQL TABLE NOT FOUND. (FOR TABLE: CHECK SEGNAME AND TABLE)
:ORA-00942: table or view does not exist
Erroneous token: hour_display
(FOC1405) SQL PREPARE ERROR.

Thanks for your assistance.
bsneln

 

[mrguru]

I believe it is your date format. Look at the .mas for PROJECT_TIME.TIMEDATE, it is probably date-time format. The way to fix the problem is to define a new date field and then base your selection off that field.

for example - if it IS a date-time field:

DEFINE FILE STAFF
EMPLOYEE/A50=STAFF.FNAME|' '| STAFF.LNAME;
XDATE/YYMD = HDATE(PROJECT_TIME.TIMEDATE, 'YYMD');
END
TABLE FILE STAFF
PRINT
.
.
.
WHERE ( XDATE GE '20040201' ) AND ( XDATE LE '20040227' ) AND ( STAFF.DIVISION EQ 'MIS' );
.
.