home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a044 / 3.ddi / VIDEO / LISTVDEO.RET < prev    next >
Encoding:
Text File  |  1993-08-31  |  4.0 KB  |  39 lines
  1. {\rtf1\ansi
  2. {\fonttbl{\f0\fswiss Arial;}}
  3. {\colortbl\red0\green0\blue0;\red128\green0\blue0;\red0\green128\blue0;\red128\green128\blue0;\red0\green0\blue128;\red128\green0\blue128;\red0\green128\blue128;\red128\green128\blue128;\red192\green192\blue192;\red255\green0\blue0;\red0\green255\blue0;\red255\green255\blue0;\red0\green0\blue255;\red255\green0\blue255;\red0\green255\blue255;}
  4. {\info{\author CA-RET}{\title Report title}}
  5. {\*\vrwvern1\vrwsubn0}
  6. \paperw12240 \paperh15840 \margl900 \margr900 \margt1440 \margb1440
  7. {\*\vrwcol TABLE1{\col0 0 1620 180}{\col1 1800 450 180}{\col2 2430 2970 180}{\col3 5580 1260 180}{\col4 7020 630 180}{\col5 7830 540 180}{\col6 8550 810 180}{\col7 9540 900 180}}
  8. {\*\ctrcol}
  9. \sectd \linex0 \pard
  10. {\*\vrwvar {\v0 MEDIANO\colnum1\colnam MEDIANO\len16\txt}
  11. {\v1 MEDIATYPE\colnum2\colnam MEDIATYPE\len6\txt}
  12. {\v2 STATUS\colnum3\colnam STATUS\len4\txt}
  13. {\v3 COST\colnum4\colnam COST\len8\flt}
  14. {\v4 NOOUT\colnum5\colnam NOOUT\len8\flt}
  15. {\v5 REVENUE\colnum6\colnam REVENUE\len8\flt}
  16. {\v6 TITLE\colnum7\colnam TITLE\len26\txt}
  17. {\v7 CATEGORY\colnum8\colnam CATEGORY\len11\txt}
  18. {\v8 _date{\expcr12 SystemDate()}\dat}
  19. {\v9 _pagenumber{\expcr12 PageNumber()}\int}
  20. {\*\vrwqry \qrynam QUERY1\inptyp3 \no_shores{\qry71 SELECT * FROM MEDIA (COMPATIBILITY=ANSI, LOCKING=NONE, MEDIA01.NDX/USE)} {\map MEDIANO\mapcol MEDIANO\mapnum1}
  21. {\map MEDIATYPE\mapcol MEDIATYPE\mapnum2}
  22. {\map STATUS\mapcol STATUS\mapnum3}
  23. {\map COST\mapcol COST\mapnum4}
  24. {\map NOOUT\mapcol NOOUT\mapnum5}
  25. {\map REVENUE\mapcol REVENUE\mapnum6}
  26. {\map TITLE\mapcol TITLE\mapnum7}
  27. {\map CATEGORY\mapcol CATEGORY\mapnum8}
  28. }
  29. {\*\vrwsct {\BCK15120 {\sctrct360 360 11880 15480}\nstlev1 }
  30. \pard\plain\ql {\f0\fs20 }
  31. {\*\vrwsct {\PHD2424 {\sctrct900 1440 11340 3864}\nstlev1 }
  32. \pard\plain\qc {\i\f0\fs60 The Video Manager}\par\pard\plain\qc {\i\f0\fs28 }\par\pard\plain\qc {\f0\fs44 Video List}\par\pard\plain\qc {\f0\fs36 }\par\pard\plain\trowd \trgaph90\trleft-90\cellx1710\cellx2340\cellx5490\cellx6930\cellx7740\cellx8460\cellx9450\cellx10530
  33. {\*\vrwcoldef1}
  34. \intbl \ql {\b\f0\fs20 Tape Number}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qc {\b\f0\fs20 Type}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \ql {\b\f0\fs20 Title}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qc {\b\f0\fs20 Category}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qc {\b\f0\fs20 Status}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qr {\b\f0\fs20 Cost}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qc {\b\f0\fs20 Number Out}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qr {\b\f0\fs20 Revenue}{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\row
  35. {\*\vrwsct {\BDY306 {\sctrct900 3864 11340 4170}\nstlev1 }
  36. \pard\plain\intbl \ql {\f0\fs20 {\*\varref MEDIANO\trmblk}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEDIATYPE\trmblk}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref TITLE\trmblk}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref CATEGORY\trmblk}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref STATUS\trmblk}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref COST}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref NOOUT}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref REVENUE}}{\f0\fs20 }{\*\brdwid20}\brdrt\brdrb\brdrl\brdrr\brdrs\brdrw20\cell\row
  37. {\*\vrwsct {\PFT462 {\sctrct900 13938 11340 14400}\txthgt \nstlev1 }
  38. \pard\plain\qc {\f0\fs20 }\par\pard\plain\qc {\f0\fs20 Page:}{\f0\fs20 {\*\varref _pagenumber}}{\f0\fs20 }
  39. }