home *** CD-ROM | disk | FTP | other *** search
/ Amico PC 3 / Amico_PC_3.iso / soundz / s4166.ret < prev    next >
Encoding:
Text File  |  1995-03-09  |  6.9 KB  |  146 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 \margl1584 \margr3744 \margt0 \margb0
  7.  
  8. \sectd \linex0 \pard
  9. {\*\vrwvar {\v0 TNUM\colnum1\colnam TNUM\len11\txt}
  10. {\v1 TITLE\colnum2\colnam TITLE\len41\txt}
  11. {\v2 STAR\colnum3\colnam STAR\len41\txt}
  12. {\v3 CAT\colnum4\colnam CAT\len8\txt}
  13. {\v4 USER1\colnum10\colnam USER1\len31\txt}
  14. {\v5 USER2\colnum11\colnam USER2\len30\txt}
  15. {\v6 USER3\colnum12\colnam USER3\len6\txt}
  16. {\v7 CROSS\colnum0\colnam CROSS\len8\flt}
  17. {\v8 FLAG\colnum0\colnam FLAG\len2\txt}
  18. {\v9 US1\colnum35\colnam US1\len9\txt}
  19. {\v10 US3\colnum36\colnam US3\len6\txt}
  20. {\v11 US2\colnum37\colnam US2\len7\txt}
  21. {\v12 STMO\colnum21\colnam STMO\len11\txt}
  22. {\v13 LSF\colnum22\colnam LSF\len11\txt}
  23. {\v14 C1\colnum13\colnam C1\len8\flt}
  24. {\v15 C2\colnum14\colnam C2\len8\flt}
  25. {\v16 C3\colnum15\colnam C3\len8\flt}
  26. {\v17 C4\colnum16\colnam C4\len8\flt}
  27. {\v18 C21\colnum17\colnam C21\len8\flt}
  28. {\v19 C22\colnum18\colnam C22\len8\flt}
  29. {\v20 C23\colnum19\colnam C23\len8\flt}
  30. {\v21 C24\colnum20\colnam C24\len8\flt}
  31. {\v22 CK1TIT\colnum23\colnam CK1TIT\len9\txt}
  32. {\v23 CK1\colnum24\colnam CK1\len7\txt}
  33. {\v24 CK2\colnum25\colnam CK2\len7\txt}
  34. {\v25 CK3\colnum26\colnam CK3\len7\txt}
  35. {\v26 CK4\colnum27\colnam CK4\len7\txt}
  36. {\v27 CK21\colnum28\colnam CK21\len7\txt}
  37. {\v28 CK22\colnum29\colnam CK22\len7\txt}
  38. {\v29 CK23\colnum30\colnam CK23\len7\txt}
  39. {\v30 CK24\colnum31\colnam CK24\len7\txt}
  40. {\v31 CK2TIT\colnum32\colnam CK2TIT\len9\txt}
  41. {\v32 XORR1\colnum33\colnam XORR1\len2\txt}
  42. {\v33 XORR2\colnum34\colnam XORR2\len2\txt}
  43. {\v34 TYPE\colnum5\colnam TYPE\len10\txt}
  44. {\v35 DATE1\colnum6\colnam DATE1\len9\txt}
  45. {\v36 SYM\colnum7\colnam SYM\len2\txt}
  46. {\v37 DATE2\colnum8\colnam DATE2\len9\txt}
  47. {\v38 VALUE\colnum9\colnam VALUE\len8\flt}
  48. {\v39 _date{\expcr12 SystemDate()}\dat}
  49. {\v40 _pagenumber{\expcr12 PageNumber()}\int}
  50. {\v41 field1{\expcr12 Trim(CK1TIT)}\txt}
  51. {\v42 field2{\expcr12 Trim(CK2TIT)}\txt}
  52. {\v43 field3{\expcr23 If(xorr1<> "X",stmo,"")}\txt}
  53. {\v44 field8{\expcr37 if(xorr1= "X",if(c1, ck1+" ", ""),"")}\txt}
  54. {\v45 field9{\expcr37 if(xorr1= "X",if(c2, ck2+" ", ""),"")}\txt}
  55. {\v46 field10{\expcr37 if(xorr1= "X",if(c3, ck3+" ", ""),"")}\txt}
  56. {\v47 field11{\expcr37 if(xorr1= "X",if(c4, ck4+" ", ""),"")}\txt}
  57. {\v48 field12{\expcr39 if(xorr2= "X",if(c21, ck21+" ", ""),"")}\txt}
  58. {\v49 field13{\expcr39 if(xorr2= "X",if(c22, ck22+" ", ""),"")}\txt}
  59. {\v50 field14{\expcr39 if(xorr2= "X",if(c23, ck23+" ", ""),"")}\txt}
  60. {\v51 field15{\expcr39 if(xorr2= "X",if(c24, ck24+" ", ""),"")}\txt}
  61. {\v52 field16{\expcr22 If(xorr2<> "X",lsf,"")}\txt}
  62. {\*\vrwqry \qrynam QUERY1\inptyp3 {\qry598  select 
  63. urint.TNUM,
  64. urint.TITLE,
  65. urint.STAR,
  66. urint.CAT,
  67. urint.type,
  68. urint.date1,
  69. soundz.sym,
  70. urint.date2,
  71. urint.value,
  72. urint.USER1,
  73. urint.USER2,
  74. urint.USER3,
  75. urint.c1,
  76. urint.c2,
  77. urint.c3,
  78. urint.c4,
  79. urint.c21,
  80. urint.c22,
  81. urint.c23,
  82. urint.c24,
  83.                   urint.stmo,
  84.                   urint.lsf,
  85. soundz.ck1tit,
  86. soundz.ck1,
  87. soundz.ck2,
  88. soundz.ck3,
  89. soundz.ck4,
  90. soundz.ck21,
  91. soundz.ck22,
  92. soundz.ck23,
  93. soundz.ck24,
  94. soundz.ck2tit,
  95. soundz.xorr1,
  96. soundz.xorr2,
  97.     soundz.us1,
  98.                   soundz.us3,
  99.     soundz.us2
  100.  from 
  101.     urint.DBF,
  102.               soundz.cfg} {\map TNUM\mapcol TNUM\mapnum1}
  103. {\map TITLE\mapcol TITLE\mapnum2}
  104. {\map STAR\mapcol STAR\mapnum3}
  105. {\map CAT\mapcol CAT\mapnum4}
  106. {\map USER1\mapcol USER1\mapnum10}
  107. {\map USER2\mapcol USER2\mapnum11}
  108. {\map USER3\mapcol USER3\mapnum12}
  109. {\map CROSS\mapnum0}
  110. {\map FLAG\mapnum0}
  111. {\map US1\mapcol US1\mapnum35}
  112. {\map US3\mapcol US3\mapnum36}
  113. {\map US2\mapcol US2\mapnum37}
  114. {\map STMO\mapcol STMO\mapnum21}
  115. {\map LSF\mapcol LSF\mapnum22}
  116. {\map C1\mapcol C1\mapnum13}
  117. {\map C2\mapcol C2\mapnum14}
  118. {\map C3\mapcol C3\mapnum15}
  119. {\map C4\mapcol C4\mapnum16}
  120. {\map C21\mapcol C21\mapnum17}
  121. {\map C22\mapcol C22\mapnum18}
  122. {\map C23\mapcol C23\mapnum19}
  123. {\map C24\mapcol C24\mapnum20}
  124. {\map CK1TIT\mapcol CK1TIT\mapnum23}
  125. {\map CK1\mapcol CK1\mapnum24}
  126. {\map CK2\mapcol CK2\mapnum25}
  127. {\map CK3\mapcol CK3\mapnum26}
  128. {\map CK4\mapcol CK4\mapnum27}
  129. {\map CK21\mapcol CK21\mapnum28}
  130. {\map CK22\mapcol CK22\mapnum29}
  131. {\map CK23\mapcol CK23\mapnum30}
  132. {\map CK24\mapcol CK24\mapnum31}
  133. {\map CK2TIT\mapcol CK2TIT\mapnum32}
  134. {\map XORR1\mapcol XORR1\mapnum33}
  135. {\map XORR2\mapcol XORR2\mapnum34}
  136. {\map TYPE\mapcol TYPE\mapnum5}
  137. {\map DATE1\mapcol DATE1\mapnum6}
  138. {\map SYM\mapcol SYM\mapnum7}
  139. {\map DATE2\mapcol DATE2\mapnum8}
  140. {\map VALUE\mapcol VALUE\mapnum9}
  141. }
  142. {\*\vrwsct {\BCK11760 {\sctrct288 240 15552 12000}\nstlev1 }
  143. \pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }
  144. {\*\vrwsct {\BDY4744 {\sctrct1584 0 8496 4744}\lbl \nstlev1 }
  145. \pard\plain\qr \txttrn {\*\no_blk}{\f0\fs32 {\*\varref TNUM\trmblk}}{\f0\fs32 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs36 {\*\varref TITLE\trmblk}}{\f0\fs36   }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs32 {\*\varref STAR\trmblk}}{\f0\fs32 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 Format:  }{\f0\fs28 {\*\varref TYPE\trmblk}}{\f0\fs28   Category:}{\f0\fs28  }{\f0\fs28 {\*\varref CAT\trmblk}}{\f0\fs28      }{\i\f0\fs28 {\*\varref US3\trmblk}}{\f0\fs28  }{\f0\fs28 {\*\varref USER3\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 Origin:  }{\f0\fs28 {\*\varref DATE1\trmblk}}{\f0\fs28  }{\i\f0\fs28  Purchase: }{\f0\fs28  }{\f0\fs28 {\*\varref DATE2\trmblk}}{\f0\fs28       }{\i\f0\fs28 Value: }{\f0\fs28 {\*\varref SYM\trmblk}}{\f0\fs28 {\*\varref VALUE}}{\f0\fs28       }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref US1\trmblk}}{\i\f0\fs28  }{\f0\fs28 {\*\varref USER1\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref US2\trmblk}}{\i\f0\fs28  }{\f0\fs28 {\*\varref USER2\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref field1}}{\i\f0\fs28 :}{\f0\fs28  }{\f0\fs28 {\*\varref field3}}{\f0\fs28 {\*\varref field8}}{\f0\fs28 {\*\varref field9}}{\f0\fs28 {\*\varref field10}}{\f0\fs28 {\*\varref field11}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref field2}}{\i\f0\fs28 :}{\f0\fs28  }{\f0\fs28 {\*\varref field16}}{\f0\fs28 {\*\varref field12}}{\f0\fs28 {\*\varref field13}}{\f0\fs28 {\*\varref field14}}{\f0\fs28 {\*\varref field15}}{\f0\fs28 }
  146. }