home *** CD-ROM | disk | FTP | other *** search
/ Amico PC 3 / Amico_PC_3.iso / soundz / sdzcat.ret < prev    next >
Encoding:
Text File  |  1995-03-09  |  10.0 KB  |  203 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 \margl810 \margr810 \margt1440 \margb1440
  7. {\*\vrwcol TABLE1{\col0 0 3150 180}{\col1 3330 720 180}{\col2 4230 630 180}{\col3 5040 630 180}}
  8. {\*\vrwcol TABLE2{\col0 0 1260 180}{\col1 1440 1260 180}{\col2 2880 1260 180}{\col3 4320 1260 180}}
  9. {\*\vrwcol TABLE3{\col0 0 5220 180}{\col1 5400 5220 180}}
  10.  
  11. \sectd \linex0 \pard
  12. {\*\vrwvar {\v0 TUNE\colnum0\colnam TUNE\len42\txt}
  13. {\v1 CROSS\colnum0\colnam CROSS\len8\flt}
  14. {\v2 TCAT\colnum0\colnam TCAT\len6\txt}
  15. {\v3 TTIME\colnum0\colnam TTIME\len6\txt}
  16. {\v4 TPOS\colnum0\colnam TPOS\len3\txt}
  17. {\v5 TNUM\colnum1\colnam TNUM\len11\txt}
  18. {\v6 TITLE\colnum2\colnam TITLE\len41\txt}
  19. {\v7 STAR\colnum3\colnam STAR\len41\txt}
  20. {\v8 CAT\colnum4\colnam CAT\len8\txt}
  21. {\v9 USER1\colnum5\colnam USER1\len31\txt}
  22. {\v10 USER2\colnum6\colnam USER2\len30\txt}
  23. {\v11 USER3\colnum7\colnam USER3\len6\txt}
  24. {\v12 CROSS_2\colnum0\colnam CROSS\len8\flt}
  25. {\v13 FLAG\colnum8\colnam FLAG\len2\txt}
  26. {\v14 CUSTOM1\colnum39\colnam CUSTOM1\len26\txt}
  27. {\v15 TN1\colnum0\colnam TN1\len6\txt}
  28. {\v16 TN2\colnum0\colnam TN2\len6\txt}
  29. {\v17 US1\colnum40\colnam US1\len9\txt}
  30. {\v18 US2\colnum41\colnam US2\len7\txt}
  31. {\v19 US3\colnum42\colnam US3\len6\txt}
  32. {\v20 STMO\colnum9\colnam STMO\len11\txt}
  33. {\v21 LSF\colnum36\colnam LSF\len11\txt}
  34. {\v22 SIDE1\colnum37\colnam SIDE1\len10\txt}
  35. {\v23 SIDE2\colnum38\colnam SIDE2\len10\txt}
  36. {\v24 C1\colnum10\colnam C1\len8\flt}
  37. {\v25 C2\colnum11\colnam C2\len8\flt}
  38. {\v26 C3\colnum13\colnam C3\len8\flt}
  39. {\v27 C4\colnum14\colnam C4\len8\flt}
  40. {\v28 C21\colnum15\colnam C21\len8\flt}
  41. {\v29 C22\colnum16\colnam C22\len8\flt}
  42. {\v30 C23\colnum17\colnam C23\len8\flt}
  43. {\v31 C24\colnum18\colnam C24\len8\flt}
  44. {\v32 CK1TIT\colnum19\colnam CK1TIT\len9\txt}
  45. {\v33 CK1\colnum20\colnam CK1\len7\txt}
  46. {\v34 CK2\colnum21\colnam CK2\len7\txt}
  47. {\v35 CK3\colnum22\colnam CK3\len7\txt}
  48. {\v36 CK4\colnum23\colnam CK4\len7\txt}
  49. {\v37 CK21\colnum24\colnam CK21\len7\txt}
  50. {\v38 CK22\colnum25\colnam CK22\len7\txt}
  51. {\v39 CK23\colnum26\colnam CK23\len7\txt}
  52. {\v40 CK24\colnum27\colnam CK24\len7\txt}
  53. {\v41 CK2TIT\colnum28\colnam CK2TIT\len9\txt}
  54. {\v42 XORR1\colnum29\colnam XORR1\len2\txt}
  55. {\v43 XORR2\colnum30\colnam XORR2\len2\txt}
  56. {\v44 COVR\colnum0\colnam COVR\len8\flt}
  57. {\v45 DATE1\colnum31\colnam DATE1\len9\txt}
  58. {\v46 DATE2\colnum32\colnam DATE2\len9\txt}
  59. {\v47 TYPE\colnum33\colnam TYPE\len10\txt}
  60. {\v48 NOTEZ\colnum34\colnam NOTEZ\len10\txt}
  61. {\v49 VALUE\colnum35\colnam VALUE\len8\flt}
  62. {\v50 SYM\colnum12\colnam SYM\len2\txt}
  63. {\v51 _pagenumber{\expcr12 PageNumber()}\int}
  64. {\v52 _date{\expcr12 SystemDate()}\dat}
  65. {\v53 field1{\expcr13 trim(CUSTOM1)}\txt}
  66. {\v54 field2{\expcr12 trim(ck1tit)}\txt}
  67. {\v55 field3{\expcr12 trim(ck2tit)}\txt}
  68. {\v56 field4{\expcr22 if(xorr1<>"X",stmo,"")}\txt}
  69. {\v57 field5{\expcr23  if(xorr2<> "X",lsf,"")}\txt}
  70. {\v58 field6{\expcr35  if(xorr1="X",if(c1,ck1+" ",""),"")}\txt}
  71. {\v59 field7{\expcr36   if(xorr1="X",if(c2,ck2+" ",""),"")}\txt}
  72. {\v60 field8{\expcr36   if(xorr1="X",if(c3,ck3+" ",""),"")}\txt}
  73. {\v61 field9{\expcr36   if(xorr1="X",if(c4,ck4+" ",""),"")}\txt}
  74. {\v62 field10{\expcr38   if(xorr2="X",if(c21,ck21+" ",""),"")}\txt}
  75. {\v63 field11{\expcr38   if(xorr2="X",if(c22,ck22+" ",""),"")}\txt}
  76. {\v64 field12{\expcr38   if(xorr2="X",if(c23,ck23+" ",""),"")}\txt}
  77. {\v65 field13{\expcr38   if(xorr2="X",if(c24,ck24+" ",""),"")}\txt}
  78. {\v66 field14{\expcr28 if(side2 ="" , "", "Side 1")}\txt}
  79. {\v67 field15{\expcr26 if(side2= "","", "Side 2")}\txt}
  80. {\v68 field16{\expcr25 if(notez > "","NoteZ","")}\txt}
  81. {\v69 field17{\expcr21 EXTRACT(SIDE1,1,1250)}\txt}
  82. {\v70 field19{\expcr24 if(side2 ="" ,"" ,SIDE1)}\txt}
  83. {\v71 field21{\expcr27 if(side2 ="" , "TuneZ", "")}\txt}
  84. {\v72 field22{\expcr25 if(side2 ="" , SIDE1, "")}\txt}
  85. {\*\vrwqry \qrynam QUERY1\inptyp3 {\qry770  select 
  86.     Urint.TNUM,
  87.     Urint.TITLE,
  88.     Urint.STAR,
  89.     Urint.CAT,
  90.     Urint.USER1,
  91.     Urint.USER2,
  92.     Urint.USER3,
  93.     Urint.FLAG,
  94.                   Urint.stmo,
  95. urint.c1,
  96. urint.c2,
  97. soundz.sym,
  98. urint.c3,
  99. urint.c4,
  100. urint.c21,
  101. urint.c22,
  102. urint.c23,
  103. urint.c24,
  104.                   soundz.ck1tit,
  105. soundz.ck1,
  106. soundz.ck2,
  107. soundz.ck3,
  108. soundz.ck4,
  109. soundz.ck21,
  110. soundz.ck22,
  111. soundz.ck23,
  112. soundz.ck24,
  113. soundz.ck2tit,
  114. soundz.xorr1,
  115. soundz.xorr2,
  116.           urint.date1,
  117. urint.date2,
  118. urint.type,
  119. urint.notez,
  120. urint.value,
  121.         Urint.lsf,
  122.                   Urint.side1,
  123.                   Urint.side2,
  124.               soundz.CUSTOM1,
  125.               soundz.US1,
  126.               soundz.US2,
  127.               soundz.US3
  128.  from 
  129.     Urint.DBF,
  130.               soundz.CFG
  131. } {\map TUNE\mapnum0}
  132. {\map CROSS\mapnum0}
  133. {\map TCAT\mapnum0}
  134. {\map TTIME\mapnum0}
  135. {\map TPOS\mapnum0}
  136. {\map TNUM\mapcol TNUM\mapnum1}
  137. {\map TITLE\mapcol TITLE\mapnum2}
  138. {\map STAR\mapcol STAR\mapnum3}
  139. {\map CAT\mapcol CAT\mapnum4}
  140. {\map USER1\mapcol USER1\mapnum5}
  141. {\map USER2\mapcol USER2\mapnum6}
  142. {\map USER3\mapcol USER3\mapnum7}
  143. {\map CROSS_2\mapnum0}
  144. {\map FLAG\mapcol FLAG\mapnum8}
  145. {\map CUSTOM1\mapcol CUSTOM1\mapnum39}
  146. {\map TN1\mapnum0}
  147. {\map TN2\mapnum0}
  148. {\map US1\mapcol US1\mapnum40}
  149. {\map US2\mapcol US2\mapnum41}
  150. {\map US3\mapcol US3\mapnum42}
  151. {\map STMO\mapcol STMO\mapnum9}
  152. {\map LSF\mapcol LSF\mapnum36}
  153. {\map SIDE1\mapcol SIDE1\mapnum37}
  154. {\map SIDE2\mapcol SIDE2\mapnum38}
  155. {\map C1\mapcol C1\mapnum10}
  156. {\map C2\mapcol C2\mapnum11}
  157. {\map C3\mapcol C3\mapnum13}
  158. {\map C4\mapcol C4\mapnum14}
  159. {\map C21\mapcol C21\mapnum15}
  160. {\map C22\mapcol C22\mapnum16}
  161. {\map C23\mapcol C23\mapnum17}
  162. {\map C24\mapcol C24\mapnum18}
  163. {\map CK1TIT\mapcol CK1TIT\mapnum19}
  164. {\map CK1\mapcol CK1\mapnum20}
  165. {\map CK2\mapcol CK2\mapnum21}
  166. {\map CK3\mapcol CK3\mapnum22}
  167. {\map CK4\mapcol CK4\mapnum23}
  168. {\map CK21\mapcol CK21\mapnum24}
  169. {\map CK22\mapcol CK22\mapnum25}
  170. {\map CK23\mapcol CK23\mapnum26}
  171. {\map CK24\mapcol CK24\mapnum27}
  172. {\map CK2TIT\mapcol CK2TIT\mapnum28}
  173. {\map XORR1\mapcol XORR1\mapnum29}
  174. {\map XORR2\mapcol XORR2\mapnum30}
  175. {\map COVR\mapnum0}
  176. {\map DATE1\mapcol DATE1\mapnum31}
  177. {\map DATE2\mapcol DATE2\mapnum32}
  178. {\map TYPE\mapcol TYPE\mapnum33}
  179. {\map NOTEZ\mapcol NOTEZ\mapnum34}
  180. {\map VALUE\mapcol VALUE\mapnum35}
  181. {\map SYM\mapcol SYM\mapnum12}
  182. }
  183. {\*\vrwsct {\BCK11760 {\sctrct288 240 15552 12000}\nstlev1 }
  184. \pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }
  185. {\*\vrwsct {\PHD1604 {\sctrct810 1440 11430 3044}\txthgt \nstlev1 }
  186. \pard\plain\qr {\f0\fs24 SoundZ Catalog}\par\pard\plain\qc {\f0\fs40 }\par\pard\plain\qc {\f0\fs40 {\*\varref CUSTOM1\trmblk}}{\f0\fs40 }\par\pard\plain\qc {\f0\fs36 }
  187. {\*\vrwsct {\RHD231 {\sctrct810 3044 11430 3275}\txthgt \nstlev1 }
  188. \pard\plain\ql {\f0\fs20 }
  189. {\*\vrwsct {\GHD4558 {\sctrct810 3275 11430 7833}\txthgt \rptbrk \nstlev1 {\grpvbllst TNUM}}
  190. \pard\plain\ql {\f0\fs28 {\*\varref TITLE\trmblk}}{\f0\fs28  }{\b\f0\fs28 {\*\varref TNUM\trmblk}}{\b\f0\fs28  }{\f0\fs28  }{\f0\fs24                                                                                                }\par\pard\plain\ql {\f0\fs26 {\*\varref STAR\trmblk}}{\f0\fs26      }{\f0\fs24                                                                    }{\i\f0\fs24   Format:  }{\f0\fs24 {\*\varref TYPE\trmblk}}{\f0\fs24                                                                                   }\par\pard\plain\ql {\i\f0\fs24 Purchase: }{\f0\fs24 {\*\varref DATE1\trmblk}}{\f0\fs24                }{\i\f0\fs24 Origin: }{\f0\fs24 {\*\varref DATE2\trmblk}}{\f0\fs24              }{\i\f0\fs24 Value:  }{\f0\fs24 {\*\varref SYM\trmblk}}{\f0\fs24 {\*\varref VALUE}}{\f0\fs24 }\par\pard\plain\ql {\i\f0\fs24 Category:}{\f0\fs24  }{\f0\fs24 {\*\varref CAT}}{\f0\fs24      }{\i\f0\fs24 {\*\varref US3\trmblk}}{\f0\fs24  }{\f0\fs24 {\*\varref USER3\trmblk}}{\f0\fs24 }\par\pard\plain\ql {\i\f0\fs24 {\*\varref US1\trmblk}}{\i\f0\fs24  }{\f0\fs24 {\*\varref USER1\trmblk}}{\f0\fs24 }\par\pard\plain\ql {\i\f0\fs24 {\*\varref US2\trmblk}}{\f0\fs24  }{\f0\fs24 {\*\varref USER2\trmblk}}{\f0\fs24 }\par\pard\plain\ql {\i\f0\fs24 {\*\varref field2}}{\i\f0\fs24 : }{\f0\fs24 {\*\varref field4}}{\f0\fs24 {\*\varref field6}}{\f0\fs24 {\*\varref field7}}{\f0\fs24 {\*\varref field8}}{\f0\fs24 {\*\varref field9}}{\f0\fs24 }\par\pard\plain\ql {\i\f0\fs24 {\*\varref field3}}{\i\f0\fs24 : }{\f0\fs24 {\*\varref field5}}{\f0\fs24 {\*\varref field10}}{\f0\fs24 {\*\varref field11}}{\f0\fs24 {\*\varref field12}}{\f0\fs24 {\*\varref field13}}{\f0\fs24 }\par\pard\plain\ql {\f0\fs20 }\par\pard\plain\trowd \trgaph90\trleft-90\cellx5310\cellx10710
  191. {\*\vrwcoldef3}
  192. \intbl \ql {\*\no_blk}{\i\ul\f0\fs24 {\*\varref field14}}{\i\ul\f0\fs24 }\cell\pard\plain\intbl \ql {\*\no_blk}{\i\ul\f0\fs24 {\*\varref field15}}{\i\ul\f0\fs24 }\cell\pard\plain\row
  193. \pard \intbl \ql {\*\no_blk}{\f0\fs24 {\*\varref field19}}{\f0\fs24 }\cell\pard\plain\intbl \ql {\*\no_blk}{\f0\fs24 {\*\varref SIDE2\trmblk}}{\f0\fs24 }\cell\pard\plain\row
  194. \pard \ql {\*\no_blk}{\i\ul\f0\fs24 {\*\varref field21}}{\i\ul\f0\fs24 }\par\pard\plain\ql {\*\no_blk}{\f0\fs24 {\*\varref field22}}{\f0\fs24 }\par\pard\plain\qc {\*\no_blk}{\i\f0\fs24 }\par\pard\plain\qc {\*\no_blk}{\i\f0\fs24 {\*\varref field16}}{\i\f0\fs24 }\par\pard\plain\ql {\f0\fs24 {\*\varref NOTEZ\trmblk}}{\f0\fs24 }
  195. {\*\vrwsct {\GHD231 {\sctrct810 7833 11430 8064}\txthgt \rptbrk \nstlev2 {\grpvbllst C2}}
  196. \pard\plain\ql {\f0\fs20 }
  197. {\*\vrwsct {\BDY284 {\sctrct810 8064 11430 8348}\txthgt \nstlev1 }
  198. \pard\plain\ql {\f0\fs24 }
  199. {\*\vrwsct {\GFT284 {\sctrct810 8348 11430 8632}\pagbrk \txthgt \nstlev1 {\grpvbllst TNUM}}
  200. \pard\plain\ql {\f0\fs24 }
  201. {\*\vrwsct {\PFT240 {\sctrct810 14160 11430 14400}\txthgt \nstlev1 }
  202. \pard\plain\qc {\b\i\f0\fs20 SoundZ For Windows}{\b\f0\fs20  -- Unregistered Copy}
  203. }