Liren Large Software Subsidy 5/05.iso/a/a044/3.ddi/VIDEO/LISTMEMB.RET

Text File | 1993-08-31 | 3.9 KB | 57 lines

{\rtf1\ansi
{\fonttbl{\f0\fswiss Arial;}}
{\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;}
{\info{\author CA-RET}{\title Report title}}
{\*\vrwvern1\vrwsubn0}
\paperw12240 \paperh15840 \margl2700 \margr2700 \margt1440 \margb1440
{\*\vrwcol TABLE1{\col0 0 2070 180}{\col1 2250 4590 180}}
{\*\ctrcol}
\sectd \linex0 \pard
{\*\vrwvar {\v0 MEMBERNO\colnum1\colnam MEMBERNO\len11\txt}
{\v1 MEMNAME\colnum2\colnam MEMNAME\len26\txt}
{\v2 MEMADDR\colnum3\colnam MEMADDR\len36\txt}
{\v3 MEMCITY\colnum4\colnam MEMCITY\len16\txt}
{\v4 MEMPROV\colnum5\colnam MEMPROV\len5\txt}
{\v5 POSTCODE\colnum6\colnam POSTCODE\len8\txt}
{\v6 PHONE\colnum7\colnam PHONE\len21\txt}
{\v7 MEMIDNO\colnum8\colnam MEMIDNO\len16\txt}
{\v8 CREDIRCARD\colnum9\colnam CREDIRCARD\len21\txt}
{\v9 NORENTAL\colnum10\colnam NORENTAL\len8\flt}
{\v10 RENTAMT\colnum11\colnam RENTAMT\len8\flt}
{\v11 _date{\expcr12 SystemDate()}\dat}
{\v12 _pagenumber{\expcr12 PageNumber()}\int}
{\*\vrwqry \qrynam QUERY1\inptyp3 \no_shores{\qry73 SELECT * FROM MEMBER (COMPATIBILITY=ANSI, LOCKING=NONE, MEMBER01.NDX/USE)} {\map MEMBERNO\mapcol MEMBERNO\mapnum1}
{\map MEMNAME\mapcol MEMNAME\mapnum2}
{\map MEMADDR\mapcol MEMADDR\mapnum3}
{\map MEMCITY\mapcol MEMCITY\mapnum4}
{\map MEMPROV\mapcol MEMPROV\mapnum5}
{\map POSTCODE\mapcol POSTCODE\mapnum6}
{\map PHONE\mapcol PHONE\mapnum7}
{\map MEMIDNO\mapcol MEMIDNO\mapnum8}
{\map CREDIRCARD\mapcol CREDIRCARD\mapnum9}
{\map NORENTAL\mapcol NORENTAL\mapnum10}
{\map RENTAMT\mapcol RENTAMT\mapnum11}
}
{\*\vrwsct {\BCK15120 {\sctrct360 360 11880 15480}\nstlev1 }
\pard\plain\ql {\f0\fs20 }
{\*\vrwsct {\PHD1838 {\sctrct2700 1440 9540 3278}\txthgt \nstlev1 }
\pard\plain\qc {\i\f0\fs48 The Video Manager}\par\pard\plain\qc {\i\f0\fs28 }\par\pard\plain\qc {\f0\fs48 Member List}\par\pard\plain\qc {\f0\fs36 }
{\*\vrwgrf {\vrwlin 0 1620 7200 1620 20 0}}
{\*\vrwsct {\BDY3022 {\sctrct2700 3278 9540 6300}\nstlev1 }
\pard\plain\trowd \trgaph90\trleft-90\cellx2160\cellx6930
{\*\vrwcoldef1}
\intbl \qr {\b\f0\fs20 Member ID}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMBERNO\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Member Name}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMNAME\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Address}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMADDR\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 City}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMCITY\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Province}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMPROV\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Zip/Postal Code}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref POSTCODE\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Telephone}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref PHONE\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Memidno}\cell\pard\plain\intbl \ql {\f0\fs20 {\*\varref MEMIDNO\trmblk}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Number of Rentals}\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref NORENTAL}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\b\f0\fs20 Total Rent Amount}\cell\pard\plain\intbl \qr {\f0\fs20 {\*\varref RENTAMT}}{\f0\fs20 }\cell\pard\plain\row
\pard \intbl \qr {\f0\fs20 }\cell\pard\plain\intbl \qr {\f0\fs20 }\cell\row
{\*\vrwgrf {\vrwlin 0 2842 7200 2842 20 0}}
{\*\vrwsct {\PFT462 {\sctrct2700 13938 9540 14400}\txthgt \nstlev1 }
\pard\plain\qc {\f0\fs20 }\par\pard\plain\qc {\f0\fs20 {\*\varref _pagenumber}}{\f0\fs20 }
}