DBASE LESSON 1 | DBASE III PLUS | DBASE COMMANDS

DBASE

Dbase uses a date of based structured language. We can create data based files and program files. Dbf contains the information used by programs

CREATE:

This command is used to create a data based file in a data based file we can enter records.

Type of Fields

1) Character Type: In a character type field we can enter 1 to 19.
2) Numerical Type: In a numeric type field we can enter 1 to 19 digits including decimal points and signs.
3) Date Type: We can enter only 8 digits format is MM/DD/YY
4) Memo Type: We can enter the text up to 5000 characters.
5) Logical: We can enter the answer in the form of either true or false it accepts only single character 'T' or 'F'.

for Exmaple:-

Field Name	Field Type	Width	Decimal Points
Sl No	Numeric	3	0
Name	Character	15	-
Date of Birth	Date	8	-

• Note: Upto 128 Fields can be entered into a dbase structure

Programmable function keys for Dbase:-

F2 - Assist
F3 - List
F4 - Dir
F5 - Display Structure
F6 - Display Status
F7 - Display Memory
F8 - Display
F9 - Append
F10 - Edit

Dbase can operate in two types of mode :-

1. Assist Mode
2. Dot Mode

DBASE COMMANDS

1) CREATE:

This command is used to create dbase files.
Syn:   .create file-name
Ex:     .create Asha

2) ^W or ^End (Save):

This command is used to save the program files, dbase structure and records
[^W or ^End]

3) LIST:

This commands is used to display all the records in used dbf files.
Syn:    .use file-name
Ex:      .List  or F3

4) APPEND:

This command is used to add the records at the end of files curtly in use.
Syn:   .use file-name
          .Append or F9

5) EDIT:

This command is used to modify the records in dbf files.
Syn:    .use file-name
           .Goto 2
           .Edit or F10
Here 2 is the record number. So make changes in it and press ^W or ^End.