Database Reference
In-Depth Information
Once again, we could edit the CDREPORT script (EDIT
CDREPORT) to add a title, adding highlighted lines.
DEFINE CDNUM=9
COLUMN CDTITLE FORMAT A15 WRAP
COLUMN NAME FORMAT A12 TRUNCATE HEADING "Artist Name"
COLUMN SONGTITLE HEADING "Song|Title" FORMAT A20 WORD_WRAP
SET LINESIZE 60
TTITLE LEFT 'Music CD # ' CDNUM -
CENTER 'User: ' SQL.USER RIGHT 'Page:' SQL.PNO SKIP 2
SELECT M.TITLE CDTITLE, A.NAME, S.TITLE SONGTITLE
FROM MUSICCD M JOIN CDTRACK T ON (M.MUSICCD_ID=T.MUSICCD_ID)
JOIN SONG S ON (T.SONG_ID=S.SONG_ID)
JOIN ARTIST A ON (S.ARTIST_ID=A.ARTIST_ID)
WHERE M.MUSICCD_ID = &CDNUM
ORDER BY 1,2,3
/
UNDEFINE CDNUM
Figure 8.19
The Report Now
Has a Title.
