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