×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data Types

Data Types

Data Types

(OP)
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

RE: Data Types

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.

RE: Data Types

(OP)
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


RE: Data Types

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' );
.
.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close