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