Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 5 / 05.iso / a / a036 / 5.ddi / TUTORIAL.ZIP / D504 < prev next >

Wrap

Text File | 1993-03-09 | 3.3 KB | 212 lines

*504010 C11,0 réü╪Layout Fields Condition Update Exit r╞üç11:34:42 am rüé≡┌ î─┬ ï─┬ è─┬ ç─┬ ï─┬ å─┬ ì─┐ rüâ≡│Book.dbf ä │FIRSTNAME │LASTNAME │TITLE │PUBLISHER │YEAR │CALLNUMBER │ rüä≡╘ î═╪ ï═╪ è═╪ ç═╪ ï═╪ å═╪ ì═╡ réàâ î rÄà≡│ rÜà≡│ rñà≡ │ r¡à≡│ r╣à≡│ r╗à≡ r└à≡│ r╬à≡│ réÆÿ╓ râÆ≡View rçÆÿ ê─╥ Å─┬ Å─┬ Å─┬ Å─┐ réôÿ║ râô≡<NEW> rÅôÿ║ rÉô≡Book-> rƒôÿ│ ráô≡Book-> r»ôÿ│ r░ô≡Book-> r┐ôÿ│ r└ô≡Book-> r╧ôÿ│ réöÿ║ rÅöÿ║ rÉö≡FIRSTNAME rƒöÿ│ ráö≡LASTNAME r»öÿ│ r░ö≡TITLE r┐öÿ│ r└ö≡PUBLISHER r╧öÿ│ réòÿ╙ î─╨ Å─┴ Å─┴ Å─┴ Å─ rüù·Query ║C:\dbase\samples\<NEW> ║File 1/1 ï ║ î ║ î râÿ╪Next field:Tab Add/Remove all fields:F5 Zoom:F9 Prev/Next skeleton:F3/F4 q╧ÿ╕N,,,,,, a7,P,,,,,, *504020 C14,1 rçç±┌ ╜─┐ rçê±│ The boxes at the bottom are called the view skeleton. ç │ rçë±│ This shows the fields to be used in the view and the order │ rçè±│ in which they will be presented. £ │ rçï±└ ╜─┘ ré╥°╓ rç╥° ê─╥ Å─┬ Å─┬ Å─┬ Å─┐ ré╙°║ rÅ╙°║ rƒ╙°│ r»╙°│ r┐╙°│ r╧╙°│ ré╘°║ rÅ╘°║ rƒ╘°│ r»╘°│ r┐╘°│ r╧╘°│ ré╒°╙ î─╨ Å─┴ Å─┴ Å─┴ Å─ q╧╪°S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *504030 C3,0 réÆÿ╓ rçÆÿ ê─╥ Å─┬ Å─┬ Å─┬ Å─┐ réôÿ║ rÅôÿ║ rƒôÿ│ r»ôÿ│ r┐ôÿ│ r╧ôÿ│ réöÿ║ rÅöÿ║ rƒöÿ│ r»öÿ│ r┐öÿ│ r╧öÿ│ réòÿ╙ î─╨ Å─┴ Å─┴ Å─┴ Å─ q╧ÿÿP,1,,,,, a1,P,,,,,, *504040 C14,1 rëê±The first step in creating a view query is specifying which rëë±records to include. You want only those records containing rëè±books published after 1986. à q╧ÿ±S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *504060 C14,1 rëê±This information is in the Year field. r░êßPress End r╣ê± to move to rëë±the CALLNUMBER field, then rñëßpress SHIFT-Tab r│ë± to move back à rëè±to YEAR. ¼ rºÅ╕ º rºÉ╕ º rºæ╕ º q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,P,,,,&H004F,, a8,C,D002,,,&H0040,, *504070 C14,0 réà≡ î r┴àâ ì rÑù·eld 6/6 râÿ╪Prev/Next field:Shift-Tab/Tab Data:F2 Size:Shift-F7 Prev/Next skel:F3/F4 q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,P,,,,&H000F,, a8,C,D002,,,&H003F,, *504080 C0,3 r║àâ å r┴àÿ ì r⌐ù·5/6 q║àâP,1,,,,, a1,P,,,,,, *504100 C0,3 r║àâ rëê±To specify the condition for all books published after à rëë±1985, rÅëßtype >"1985" r¢ë±. Quotation marks in dBASE IV indicate rëè±information that must be compared character by character. q║àâK,,5X/CTI,,,, a4,P,,,,,, a7,G,,,,,, a8,P,,,,>"198,, *504110 C0,7 r╞üç11:34:42 am r║àâ>"198 q┐à╕S,,,,,, a7,G,,,,,, a8,P,,,,&H0D,, a8,P,,,,&H35,, *504115 C0,7 r╞üç11:34:42 am r└é≡─┬ ì─┐ r└â≡ │CALLNUMBER │ r└ä≡═╪ ì═╡ r┐àâ5 r┴à≡│ r╬à≡ │ q└àâS,,,,,, a7,G,,,,,, a8,P,,,,&H0D,, a8,P,,,,&H22,, *504118 C0,7 r╞üç11:34:42 am r┴é≡─┬ ì─┐ r┴â≡ │CALLNUMBER │ r┴ä≡═╪ ì═╡ r└àâ" r┬à≡│ r╧à≡ │ q┴àâP,1,,,,, a1,P,,,,,, *504120 C14,1 rëê±>"1985" tells dBASE IV that you want only those records rëë±that contain a number greater than 1985 in the Year field. rëè± ║ r¿Éß Press ─┘ r▓É± to continue or r┬ÉßF5 r─É± to exit q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,P,,,,&H0D,, a8,C,D002,,,&H003F,, *504140 C12,1 rëêßPress F2 Data rùê±to see the filtered data from your file. å rëë± ╝ rêè± ╝ rºÅ≡ º rºÉ≡ º rºæ≡ º q╧ÿ╕S,,,,,, QC1 a7,G,,,,,, a8,C,D505,,,&H0D,, a8,C,D505,,,&H003C,, a8,C,D002,,,&H003F,,