*4-010
xÇÇÅ
rââ┘  Introduction to dBASE III PLUS  
rÑâ∙∙
rªâ┘  
r¿â┘Session 4
r▒â┘  
r│â∙∙
r┤â┘  
r╢â∙Modify
r╝â┘ ö 
râäτ ├─ ä 
râàç ╬ 
râåç ╬ 
râçç ╬ 
râêç ╬ 
râëç å In this session, you will ¼ 
ræìº■
röìÅModify
rÜìç the structure of your database file
ræź■
röÅÅOrganize
r£Åç your file with the SORT command
rææº■
röæÅUpdate
rÜæç your file with the DELETE, RECALL, & PACK
r╞æçcommands
rñù┘  Press  
r¡ù∙──┘
r▒ù┘  to continue  or  
r─ù∙F5
rƗ٠to exit  
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*4-014
ràâ┘Modify ▒ 
rëëÅ ┼ 
rëèÅ ┼ 
rëïÅ ┼ 
rëîÅ ┼ 
rëìÅ ┼ 
rëÄÅ ┼ 
rëÅÅ ┼ 
rëÉÅ ┼ 
rëæÅ ┼ 
q╧ÿÅN,,,,,,
a7,P,,,,,
*4-015
rÄëÅWhenever you need to modify the structure of your 
rÄïÅdatabase file by adding or deleting fields, changing
rÄìÅfield names or lengths, or rearranging the order of
rÄÅÅfields, you do so with the 
r⌐ÅçMODIFY STRUCTURE
r╣ÅÅ command.
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*4-020
rÄëÅIn the following example, you will make two changes
rÄïÅto the structure of your database file. £ 
rÄìÅ │ 
rïÅÅ ╞ 
rÄæÅ Æ 
râù╕ F9 to review 
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,4-010,,,&H0043,
*4-025
rÄëÅ1. You will insert a new field in the structure of your file.
rÄïÅ ¬ 
rÄîÅThe field you insert will be a logical field. Logical
r─îÅfields
rÄÄÅallow you to supply 
róÄçYes
rÑÄÅ or 
r⌐ÄçNo
r½ÄÅ information.
rüÅÅ ╨ 
rÄÉÅThe new field will allow you to see at a glance if you've
rææÅ Ä 
rÄÆÅfinished the activities of any given event.
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,4-010,,,&H0043,
*4-030
rÄëÅ2
rÜëÅchange the width of the 
r▓ëçWHO
r╡ëÅ field from 30 to 25. 
rÄîÅIt is always good practice to keep field widths to a ë 
rÄÄÅminimum when
r¢ÄÅusing dBASE III PLUS. ë 
rÉÉÅis allows more space on the disk for greater record ä 
rÄÆÅstorage. ú 
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,4-010,,,&H0043,
*4-033
xÇÇ╨
rüü╨ Set Up  Create 
ræüé Update 
rÖü╨ Position  Retrieve  Organize Modify Tools  
r┼üé00:00:00 am
ræé╨╔ ë═╗
ræâ╨║
rÆâé Append  
r¢â╨║
ræä╨║ ë─║
ræà╨║ Edit ä ║
ræå╨║ Display ║
ræç╨║ ë─║
ræê╨║ Browse  ║
ræë╨║ Replace ║
ræè╨║ ë─║
ræï╨║ Delete  ║
ræî╨║ Recall  ║
ræì╨║ Pack ä ║
ræÄ╨╚ ë═╝
r¬ò°  
rüùéASSIST è ║<A:>║TODOLIST Å ║Opt: 1/8 ï ║ å ║ ç 
q╧ÿéN,,,,,,
a7,P,,,,,
*4-036
rƒâÅ ò 
rƒäÅ  Press 
rºä° M 
r¬äÅ to open  
rƒàÅ ò 
rƒåÅ  the 
rÑåçModify
r½åÅ menu.   
rƒçÅ ò 
q╧ÿÅN,,,,,,
a7,P,,,,,
*4-040
r╣â╕
rºä° 
r⌐ä° 
d╣ä╕││
r┤å╕ à─┘
rüö╕┌ Ä─┐
rüò╕│
râò╕F9 to review
rÉò╕│
r╜òÅ Press  
r┼òçF5
r╟òÅ  to exit 
rüû╕└ Ä─┘
r»ùéRec
r╢ùé10
q╧ÿ╨S,,,,,,
a7,G,,,,,
a8,P,,,,&H6D,
a8,C,M002.T,,,&H003F,
a8,T,4-040,,,&H0043,
a8,P,,,,&H4D,
*4-043
ræü╨ Update 
ræé╨ ⌐ 
ræâ╨ Ä 
r┤â╨ å 
ræä╨ Ä 
ríäÅ æ 
r┤ä╨ å 
ræà╨ Ä 
ríàÅ æ 
r┤à╨ å 
ræå╨ ï 
ríåÅ æ 
r┤å╨ å 
ræç╨ Ä 
r┤ç╨ å 
ræê╨ ï 
ræë╨ ï 
ræè╨ ï 
ræï╨ ï 
ræî╨ ï 
ræì╨ ï 
ræÄ╨ ï 
rüö╨ É 
rüò╨ É 
rüû╨ É 
q╧ÿ╨N,,,,,,
a7,P,,,,,
*4-046
rüü╨ Set Up  Create  Update  Position  Retrieve  Organize
r╢üé Modify 
r╛ü╨Tools  
r┼üé00
rƒé╨ ù ╔ Å═╗
r┤â╨  ║
r╖âé Database file 
rƃк
róäÅPress  
r¿ä° ──┘ 
r┤ä╨  ║ Format ê ║
r┤à╨  ║ View è ║
róåÅto select
r┤å╨  ║ Query ë ║
r┤ç╨  ║ Report ê ║
rƒêÅ   
róêçDatabase file
r»êÅ à 
r┤ê╨  ║ Label ë ║
rƒëÅ ò 
r┤ë╨  ╚ Å═╝
r╢ùé6
q╧ÿ╨S,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*4-047
r£é╨ ▒ 
r£â╨ ▒ 
r£ä╨ ▒ 
r£à╨ ▒ 
r£å╨ ▓ 
r£ç╨ ▒ 
r£ê╨ ▒ 
r£ë╨ ▒ 
r£è╨ ▒ 
r£ï╨ ▒ 
r╣ò╨ ÿ 
rüû╨Command: MODIFY STRUCTURE
q╧ÿ╨N,,,,,,
a7,C,M402.T,,,,
 
r£å╨ ▓ 
r£ç╨ ▒ 
r£ê╨ ▒ 
r£ë╨ ▒ 
r£è╨