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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print to a HOLD File; then Print From the HOLD File 1 Field at a Time

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Jan 26, 2001
522
US
I have a report which has 100 columns and it will not print because there are too many fields to print.

However, this code DOES work:
DEFINE FILE CAR
LCOUNTRY/A20=COUNTRY | '1234567890';
END
TABLE FILE CAR
"&FOCREL"
PRINT
-REPEAT ENDREP FOR &I FROM 1 TO 250
LCOUNTRY AS 'COUNTRY, &I'
-ENDREP
ON TABLE PCHOLD FORMAT EXL2K
END

-*******************
What I need to do is save my SQLOUT to a HOLD file,
then print 1 field at a time until all fields are exhausted, then print the next row.

Is this Possible?


Thanks,

Leo ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top