*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æû╨A:
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,M