DBASE LESSON 4 | DBASE III PLUS | DBASE COMMANDS

DBASE LESSON 4:

26) PACK:

This command permanently removes records that have been marked for deletion from the dbase file
Syn:   .Pack

27) ERASE:

This command erases the file from the specified disk directory an open file can not be erased, it must be closed first.
Syn:  . Erase file-name.dbf
            File has been deleted.

28) ZAP:

This command permanently removes all the records at a time from an active dbase or database structure intact.
Syn:  .Zap
            or
         .Delete all
         .Pack

29) SORT:

This command is used to copy all the names of an active dbase file ine alphabetical order and also to copy the marks to a new file in increasing order or decreasing order.
Syn:  .Sort on Field-name  to  New-File-Name.dbf
Ex:    .Sort on Name to Balu.dbf

30) USE:

The "Use" command along with no file name closes a dbase file.
Syn: .Use
         or
        .Close

31) QUIT:

This is used to exit from dbase.
Syn: .Quit

32) FOR Option:

It searches all the records and displays those records that match to the given command excluding current cursor position.
Ex:   .List  For  name= "Asha"
So here records having name as "Asha" will be displayed.

Record No.	Name	Father Name	Address
1	Asha	Ravi	MLG
2	Asha	Hari	NKL