DBASE LESSON 3 | DBASE III PLUS | DBASE COMMANDS

DBASE LESSON 3:

16) !(Exclamation mark):

This is use to run a DOS command.
Syn:   .!copy
          or
         .Del             etc..

17) SET STATUS ON:

This command is used to on the status line.
Syn:   .Set Status On

18) SET STATUS OFF:

This command is used to off the status line.
Syn:   .Set Status Off

19) ?DATE( ) :

This is used to display the date.
Syn:   .?date( )

20) ?TIME( ): 

This is used to display the time.
Syn:   .?time( )

21) ? (Print):

The Print command is used to do any mathematical function.
Syn: ?(2+3)
Output: 5

22) ?Min( ):

This command will compare the given numbers and shows the smaller value as output. We can give both  +ve and -ve numbers
Syn:  .?Min(25,10)
Output: 10

23) ?Max( ):

This shows the maximum number as output.
Ex:    ?Max(5,100)
Output: 100

24) DELETE:

This command is used to remove a record or group of records.
Note: These records are not totally removed from the dbase file. A record, marked, for deletion can be recognized by asterisk (*) to the left of the record during list or display.
Syn:   .Use file-name
          .Goto Record-No
          .Delete
           Record deleted.

25) RECALL:

This command is used to recall the record that has been marked for deletion.
Syn:   .Goto Record-No
         .Recall