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

Read More

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

Read More

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

Read More

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.

Read More