Shareware Overload

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

/ Shareware Overload / ShartewareOverload.cdr / database / db3plttr.zip / M201.T < prev next >

Wrap

Text File | 1985-12-26 | 8KB | 528 lines

*2-010 xÇÇÅ rââ┘ Introduction to dBASE III PLUS rÑâ∙∙ rªâ┘ r¿â╤Session 2 r▒â┘ r│â∙∙ r┤â┘ r╢â∙Create r╝â┘ ö râäτ ├─ ä râàç ╬ râåç ╬ râçç ╬ râêç ╬ râëç å In this session, you will ¼ rÅìº■ rÆìÅCreate rÿìç the structure for your database file r╛ìç- ToDoList rÅÅº■ rÆÅÅAppend rÖÅçrecords to your file rÅæº■ rÆæÅPrint rÿæça copy of the contents of your file rñù┘ Press r¡ù∙──┘ r▒ù┘ to continue or r─ù∙F5 r╞ù┘ to exit q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *2-020 xÇÇ╨ rüà╨A> röêÅ ▒ röëÅ To start up róëçdBASE III PLUS r░ëÅ, type Å röèÅ ▒ röïÅ rûï dbase r¢ïÅ at the operating system prompt è röîÅ ▒ röìÅ ƒ then press r┐ì ──┘ r├ìÅ röÄÅ ▒ r╖ù╨ Ü qâà╨K,,10A/I,,,, è a7,G,,,,, a8,P,,,,dbase à , a8,P,,,,dBASE à , a8,P,,,,DBASE à , *2-030 xÇÇ╨ rüüé Set Up rëü╨ Create Update Position Retrieve Organize Modify Tools r┼üé00:00:00 am rüé╨╔ ô═╗ rüâ╨║ réâé Database file à ròâ╨║ rüä╨║ ô─║ rüà╨║ Format for Screen ║ ríàÅ ¿ rüå╨║ Query ì ║ ríåÅ Your first step is to r╣åçcreate r┐åÅ a ê rüç╨║ ô─║ ríçÅ ¿ rüê╨║ Catalog ï ║ ríêÅ database file. ÿ rüë╨║ View Ä ║ ríëÅ ¿ rüè╨║ ô─║ ríèÅ ¿ rüï╨║ Quit dBASE III ä ║ ríïÅ Press r¬ï r½ïÅ to open the r║ïçCreate r┴ïÅ menu. rüî╨╚ ô═╝ ríîÅ ¿ rüòê r╗òç r╝òÅPress r┴òç F5 r╟òÅto exit r╬òç rüùéASSIST è ║<A:>║ ù ║Opt: 1/6 ï ║ å ║ ç q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H004D, a8,P,,,,&H63, a8,C,M002.T,,,&H003F, *2-040 rüü╨ Set Up rëüé Create ræü╨ Update rüé╨ ê ╔ Å═╗ rüâ╨ ê ║ rèâé Database file rÖâ╨║ rüä╨ ê ║ Format ê ║ rüà╨ ê ║ View è ║ rüå╨ ê ║ Query ë ║ rúåÅThe option r»åç Database file r┴åÅis rüç╨ ê ║ Report ê ║ rüê╨ ê ║ Label ë ║ rúêÅalready highlighted. rüë╨ ê ╚ Å═╝ rüè╨ ò rüï╨ ù rúïÅ Press r«ï ──┘ r▓ïÅ to select it. å rüî╨ û q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *2-045 rÜâ╨╔ ä═╗ rÜä╨║ r¢äé A: rƒä╨║ rÜà╨║ B: ║ rÜå╨╚ ä═╝ rúåç á rúêç ò r╛ïÅdrive r─ïçA rüû╨Command: CREATE r╢ùé2 q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *2-050 rÜâ╨ å rÜä╨ å rÜà╨ å ríà╨ ¿ rÜå╨ å ríå╨ ¿ ríç╨ ¿ ríê╨ ¿ ríë╨ ¿ rüè╨ Å ╔ ▓═╗ à rüï╨ Å ║ Enter the name of the file: r»ïé ô r┬ï╨ ║ à rüî╨ Å ╚ ▓═╝ à rÑìÅ ª rÑÄÅ Type r«Ä todolist r╢ÄÅ and press r├Ä ──┘ r╚ÄÅ rÑÅÅ ª rÑÉÅ ª rÑæÅ To correct any typing errors, use rÑÆÅ the r½Æç r«ÆÅ, r░ÆçIns r│ÆÅ, and r╣ÆçDel r╝ÆÅ keys. ë r╦Æê å rÑôÅ ª r╖ò╨ Ö rüû╨Command: CREATE ræû╨C: q»ïéK,,20A/IT,,,, a7,G,,,,, a9,P,,,,list, a9,P,,,,List, a9,P,,,,LIST, *2-060 rüü╨ ╨ rüé╨ ╨ rüâ╨ rëâ╨ » Bytes remaining: 4000 rüä╨ ╖ rüà╨╔ æ═╦ ì═╦ Ä═╦ û═╗ rüå╨║ CURSOR <-- --> ║ ä INSERT ║ à DELETE ║ Up a field: ä ä ║ rüç╨║ Char: ä ║ Char: Ins ║ Char: Del ║ Down a field: ä ║ rüê╨║ Word: Home End ║ Field: ^N ║ Word: ^Y ║ Exit/Save: ä ^End ║ rüë╨║ räë╨Pan: ä ^ ^ ║ Help: F1 ║ rñë╨Field: ^U ║ Abort: ë Esc ║ rüè╨╚ æ═╩ ì═╩ Ä═╩ û═╝ rüï╨ à Field Name Type à Width Dec ì Field Name Type à Width Dec rüî╨ à ƒ═ ì ƒ═ rüì╨ 1 råìé è rÉì╨ rÆìéCharacter r¥ìé róìé rÑì╨ ª rÑÄ╨ º rÑÅ╨ ª rüÉê râÉÅ ─ r╟É╨ r╚ÉÇ r╩ÉÅ ç râæÅ You are now ready to define the rÑæçstructure r«æÅ of your database file. r╟æ╨ r╚æÇ r╩æÅ Press râÆÅ ─ r╟Æ╨ r╚ÆÇ r╩ÆÅ r╠ÆçF5 r╬ÆÅ râôÅ For the purposes of this introduction, remove the dBASE III PLUS r╟ô╨ r╚ôÇ r╩ôÅ to râöÅ instructions box from the top of the screen by pressing r╛ö F1 r└öÅ ç r╚öÇ r╩öÅ exit râòÅ ─ r╟òê r╚òÇ r╩òÅ ç rüûê É ræû╨ rüùéCREATE rùùéTODOLIST r»ùéField: 1/1 qåìéS,,,,,, a7,G,,,,, a8,P,,,,&H003B, a8,C,M002.T,,,&H003F, *2-070 xÇÇ╨ rÉâ╨ ¿ Bytes remaining: 4000 rüä╨ ╖ rüà╨ à råà°Field Name rÉà╨ Type à Width Dec ì Field Name Type à Width Dec rüå╨ à ƒ═ ì ƒ═ rüç╨ 1 råçé è rÉç╨ rÆçéCharacter r¥çé róçé rïë° ræëÅ ║ rïè°│ ræèÅ You can specify up to 4 things about each field. ê rïï°│ ræïÅ The first is the ¿ rïî°│ ræîÅ ║ rïì°└─── ræìÅ rôìçField Name r¥ìÅ « ræÄÅ ║ ræÅÅ The field names for this example are r╕Åçwhat r╝ÅÅ, r╛Åçwho r┴ÅÅ, ë ræÉÅ rôÉçphone rÿÉÅ, rÜÉçwhen r₧ÉÅ, ráÉçwhere rÑÉÅ, and r½Éçactivity r│ÉÅ. ù rææÅ ║ ræÆÅ Type rÖÆ what r¥ÆÅ for the name of Field 1 and press r┬Æ ──┘ r╞ÆÅ . ræôÅ ║ ræöÅ dBASE III PLUS converts what you type into uppercase. ræòÅ ║ r╦ò╨ å rüùéCREATE è ║<A:>║TODOLIST Å ║Field: 1/1 ë ║ å ║ ç qåçéK,,10M/I,,,, a7,G,,,,, a8,P,,,,WHAT å , *2-080 råà╨Field Name rÆà°Type råçéWHAT rÆçéC rïëê ë röë° rÿëê ç r┼ëÅ î rïèê ë röè°│ ròèê è rƒèÅ The second field specification is Å rüïê ô röï°│ ròïê è rƒïÅ ä r┼ïÅ î rëîê ï röî°└ ê─ r¥îê ríîçType r┼îÅ î rëìê û r┼ìÅ î rëÄÅ Ö r┼ÄÅ î rëÅÅ There are 5 types of fields in dBASE III PLUS: ÿ rëÉÅ » r┼ÉÅ î rëæÅ à rÄæçCharacter à Numeric å Date à Logical à Memo r├æÅ Ä rëÆÅ ╚ rëôÅ ╖ r└ôç┌ Ä─┐ r╨ôÅ rëöÅ Press rÆö ──┘ rûöÅ for an explanation of the 5 types. à r┐öç │ r┴öÅ r├öçF5 r┼öÅ to exit r╧öç│ r╨öÅ rëòÅ ╖ r└òç└ Ä─┘ r╨òÅ qÆçéS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *2-090 xÇÇÅ rüâÅ ╟ rüàÅ å You determine the Field Type by its intended content. ò rêê Character C rÖêº│ rƒêçCharacter r¿êÅ is for any keyboard character: r╟êç rÖëº│ rƒëÅ ¿ r╟ëç rÖèº│ rƒèÅletter, number, punctuation mark. ç r╟èç rüïç ç Numeric à N ä rÖïº│ rÜïÅ ¡ r╟ïç rüîç ÿ rÖîº│ rƒîÅ ¿ r╟îç rüìç ÿ rÖìº│ rƒìÅFields containing names, addresses, and r╟ìç rüÄç ç Date ê D ä rÖÄº│ rƒÄÅ ¿ r╟Äç rüÅç ÿ rÖÅº│ rƒÅÅtelephone numbers are character fields. rêÉç ì rÖÉº│ rêæçLogical à L rÖæº│ rêÆç ì rÖÆº│ rêôç ì rÖôº│ rêöçMemo ê M dÖöº││ ráùÅ rúùç rñù┘ Press r¡ù∙──┘ r│ù┘to continue or r─ù∙F5 r╞ù┘ to exit r╨ùÅ q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *2-100 rêêçCharacter C rƒêçNumeric rºêÅis for fields containing à r─êç ä rƒëÅ Ñ rƒèÅnumbers used in calculations. ê rêï Numeric à N rƒïÅ Ñ rƒîÅ Ñ rƒìÅFields used for an expense account or r─ìç rƒÄÅ Ñ rƒÅÅfor bookkeeping are numeric. ë r─Åç ä rƒÆÅTelephone or identification numbers are å rƒöÅkept in character fields, not numeric fields. râù╕ F9 to review q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,2-090,,,&H0043, *2-110 rêïçNumeric à N rêÄ Date ê D rƒêçDate rúêÅ is for dates in the form: r╜êç rñëÅ Ö rƒèç à rñèÅ mm/dd/yy where å r╗èç ríîÅ rƒîÅmm róîÅis a 2-digit number for month. April is 04 rƒìç ª rƒÄÅdd is a 2-digit number for day. April 1 is 04/01 rƒÅç ª rƒÉÅyy is a 2-digit number for year. rƒÆÅ æ April 1, 1986 is 04/01/86 rƒôÅ ¼ rƒöÅ ¡ q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,2-090,,,&H0043, *2-120 rêÄçDate ê D rêæ Logical à L rƒêçLogical rªêÅ is for fields containing î rºëÅ ñ ráèçY róèÅor rñèç N rºèÅ (yes/no) ¢ rºïÅ ñ rƒîÅ ráîçT ríîÅ or rñîç F rºîÅ (true/false). ù rºìÅ ñ rƒÄÅ ░ rƒÅÅ"Acct_Paid" might be a logical field in rƒÉÅa Customer Accounts Receivable file. è rƒæÅThe "Acct_Paid" field would contain Y ä rƒÆÅ(for yes) if the customer had paid the last rƒôÅinvoice, or N (for no) if the customer hadn't rƒöÅpaid. q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,2-090,,,&H0043, *2-130 rêæçLogical à L rêö Memo ê M rƒêçMemo rúêÅ is for free-form notes related ä rƒëÅ º rƒèÅto that particular record. ì rƒïÅ º rƒîÅ º rƒìÅFor example, you could use a memo field rƒÄÅ º rƒÅÅto keep notes on your customers. ç r╞Åç r╟ÅÅ rƒÉÅ ª rƒæç ¼ rƒÆÅThe memo field can be up to 5000 characters r╩Æç rƒôç ¼ r╦ôÅ rƒöÅin length. q╧ÿÅS,,,,,, a7,G,,,,, a8,C,M202.T,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,2-090,,,&H0043, Æç rƒôç ¼ r╦ôÅ rƒöÅin length. q╧ÿÅS,,,,,, a7,G,,,,, a8,C,M202.T,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,2-090