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!

  • Congratulations Andrzejek 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. mmiles

    Error FOC36249

    The name of the FOCEXEC that you have the -INCLUDE in isn't the same name as the FOCEXEC you are including is it?
  2. mmiles

    Footer for Empty report

    Case: 32261090 Product: MF Release: 706 Primary OS: MVS Date: 98/08/24 Case information refers to the Product, Release, and OS for which this question was asked. The solution may apply to other Products, Releases, and Operating Systems. Symptom: How to print a report that will contain...
  3. mmiles

    Removing Underline for Column Titles

    Put a trailing comma at the end of each title to suppress under-lines under the headers. TABLE FILE CAR PRINT TYPE AS 'Type,' BY COUNTRY AS 'Country,' ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ ENDSTYLE END
  4. mmiles

    FOCUS ERROR 1379

    (FOC1379) MAXIMUM STORED PROCEDURE PARAMETERS - %1%2%3%4 Maximum number of parameters allowed for Oracle stored procedure.
  5. mmiles

    Number of Pages in Report

    I goofed...try this (or something like it) instead. TABLE FILE CAR SUM TYPE BY COUNTRY ON COUNTRY PAGE-BREAK ON TABLE HOLD END -RUN DEFINE FILE CAR ADD TPAGE/I6 = &LINES; END SET PAGE=OFF TABLE FILE CAR HEADING "<TABPAGENO OF <TPAGE PAGES" PRINT TYPE BY COUNTRY ON COUNTRY PAGE-BREAK END
  6. mmiles

    Blank space on top of PDF's

    One last thing to try SET PAGE=NOPAGE
  7. mmiles

    Number of Pages in Report

    TABLE FILE CAR PRINT TYPE BY COUNTRY ON COUNTRY PAGE-BREAK ON TABLE HOLD END -RUN DEFINE FILE CAR ADD TPAGE/I6 = &RECORDS; END SET PAGE=OFF TABLE FILE CAR HEADING "<TABPAGENO OF <TPAGE PAGES" PRINT TYPE TPAGE BY COUNTRY ON COUNTRY PAGE-BREAK END
  8. mmiles

    Get VALUES from FILE

    Why are you doing the define after the TABLE FILE request? This is code that I used to populate a drop down box. DEFINE FILE COMPANY OPTCOMPANY/A80 = '<OPTION VALUE="' | CMPY_NUMBER || '">' | CMPY_NAME; END TABLE FILE COMPANY SUM OPTCOMPANY BY CMPY_NAME NOPRINT &COMPWHER WHERE...
  9. mmiles

    BASEURL doesn't work as expected

    Syntax: How to Specify a Base URL SET BASEURL=url where: url Is the fully-qualified directory in which additional HTML files, graphics files, and Java applet CLASS files reside. The URL must begin with http:// and end with a closing delimiter (/). Example: Specifying a Base URL The...
  10. mmiles

    Blank space on top of PDF's

    Try SET PAGE=OFF or SET PAGE=NOLEAD.
  11. mmiles

    CANNOT MAKE SET ALL=PASS WORK

    Have you tried extracting data from both files and using MATCH FILE logic with the appropriate OLD-NOT-NEW, OLD-AND-NEW, etc.
  12. mmiles

    Column Spacing in PDF Reports

    Try setting the FONT size smaller via stylesheet commands. ON TABLE SET STYLE * TYPE=REPORT, SIZE=9,GRID=OFF, LEFTMARGIN=.25, RIGHTMARGIN=.25, FONT=COURIER, $ ENDSTYLE
  13. mmiles

    CANNOT MAKE SET ALL=PASS WORK

    There are certain commands (Dialog Manager) that need to have the hypnen. Other SET commands (non-Dialog Manager) do not require them.
  14. mmiles

    Calculating a value in the SUBTOTAL

    DEFINE FILE CAR SUBA/I6 = 55; SUBB/I6 = 75; END TABLE FILE CAR PRINT SUBA SUBB COMPUTE PCT/D6.2 = ((SUBB - SUBA)/SUBB) * 100; BY COUNTRY ON COUNTRY RECOMPUTE ON COUNTRY SUB-TOTAL IF RECORDLIMIT EQ 5 END Returns PAGE 1 COUNTRY SUBA SUBB PCT ENGLAND 55 75 26.67 *TOTAL...
  15. mmiles

    CANNOT MAKE SET ALL=PASS WORK

    Are you using -SET ALL=PASS or SET ALL=PASS (without the leading hyphen?

Part and Inventory Search

Back
Top