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