Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bsneln

    Data Types

    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...
  2. bsneln

    Data Types

    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 *...
  3. bsneln

    Year Format

    Got the procedure to work now by defining a new field as the YY format and are no longer receiving the error message. Thanks!!
  4. bsneln

    Year Format

    Okay. I did that. We get the following error message: (FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: DEFINE Thanks for your help! bsneln
  5. bsneln

    Year Format

    To initiate this report, we will have the user select the "Year" for the report. Then we want the report to display: Title: Year To Date Summary Headings: PAY PERIOD example - 02/15/2000 REGULAR OVERTIME ANNUAL SICK SICK FAMILY STATE COMP FED COMP HOLIDAY COMP HOLIDAY OTHER...
  6. bsneln

    Year Format

    We have a field with a MDYY format. We need to be able to select just the year for the report to run. When we select the year, the report will display showing the MDYY formatted in another column. How do we do this?

Part and Inventory Search

Back
Top