DBASE LESSON 5 | DBASE III PLUS | PROGRAMMING IN DBASE

LESSON 5: PROGRAMMING IN DBASE

MODIFY COMMAND:

This command is used to create a program file. ^W is used to save the file.
Syn:   .Modify Command  Program-Name

DO:

This command followed by file name at the Dot promt is used to execute or run the program.
Syn:   .Do Program-Name

SET TALK OFF: 

While execution of any program, Dbase passes on some messages. These meassages can be stopped with SET TALK OFF command. By Default it is SET TALK ON.

SET DATE: 

By default computer follows the "American" format i.e. MM/DD/YY. We can change it to other formats by SET DATE command. Different formats are
American                - MM/DD/YY
British                     - DD/MM/YY
French & German   - DD.MM.YY
Italian                      - DD-MM-YY
ANSI                       - YY.MM.DD
If we want to change the date to "British" format we have to give
Syn:   . SET DATE  BRITISH

STORE:

By using STORE command we can store data in M.M.U under any name given by us. For example to store 50 in a memory location called "Num 2" we can give
Syn:  . STORE Numbers/Expression to variable name
Ex:    . STORE "HELLO"  to B

PRINT (?): 

This command is used to display the memory variable (HELLO) as Output.
Syn:   . STORE   "HELLO"  to B
           . ?B

INPUT: 

This command is used to enter numberic data into a dbase program.
Syn:  INPUT " Enter Mathematics Marks" to M

ACCEPT:

This command is used to enter alpha-numeric data into a data program.
Syn: ACCEPT  "Enter Your Name" to Name

EXAMPLE OF DBASE PROGRAM

Program 1:  Program to print three times name in three lines.

. MODIFY COMMAND  FILE-NAME

SET TALK OFF
SET STATUF OFF
STORE  "Asha"  to B
?B
?B
?B

^W (Save)

. DO   FILE-NAME

OUTPUT: 
Asha
Asha
Asha