DBASE LESSON 2 | DBASE III PLUS | DBASE COMMANDS

DBASE LESSON 2:

6) DIR:

This command is used to display all the dbase files
Syn:   .dir or F4 

7) DIR.PRG:

This command is used to display PRG or Program files
Syn:   .dir.prg

8) INSERT: 

This command used to insert records between and records
Syn:   .Goto Record-No
          . Insert

9) BROWSE: 

This command is used to display the first and last records and any particulars record metioned. Freeze is used to change the reocrds of a particular field. We can also add records.
Syn:   .Browse 
          ^Home

10) DISPLAY:

This command is used to display the particular record.
Syn:   .Use File-name
          .Goto Top         (First Record)
          . Display or F8

Note: The DISPLAY command is same as LIST command.
The main difference between these two commands is

1. The output of the DISPLAY command is morethan 20 lines long, the command will pause (stop) after each 20 lines  and wait for a key to be pressed to continue.
2. The output of the LIST command does not pause till the end of the file. 

11) DISPLAY ALL:

This command is used to display all the records in page wise.
Syn:   .Use file-name.
          .Display all

12) DISPLAY STRUCTURE:

This command is used to display the Dbase structure i.e. field name, their type and length, file-name, number of records in the file, date when file is last updated.
Syn:   .Use file-name
          . Display structure    or  F5

13) MODIFY STRUCTURE:

This command is used to make changes in the Dbase structure.
Syn:   .Modify Structure

• Ese  or ^Q is used to exit, leaving the Dbase structure in its original states
• ^W or ^End is used to exit changing the structure to the new definition.

14) REPLACE:

This command is used to change the contents of specified fields in the active Dbase file.
Syn1:   .Use file-name
          .Replace all  AVG with  TOTAL/6  (IF No of Subjects = 6)
                                   or
          .Replace all VILL  with  "HYD"

Syn2:   .Use file-name
            .Goto Record-No
            .Replace TOTAL with  TEL+HIN+ENG+MAT+SCI+SOC
           
Syntax:  .REPLACE  or REPLACE ALL   FIELD-NAME  with  "Text"/ Formula Code

15) COPY:

This command is used to copy records, fields and dbase files to new dbase files
Syn:  .Copy  File-name