FoxPro Commands - Part 1

• FoxPro is SEMI-RDBMS
• Unlike other RDBMS systems, in FoxPro each database can contain only one table.
• Hence, the single table is called as database in this tutorial

In FoxPro, first four characters of any command is enough to execute

For e.g.:- crea ==> create

1. TO OPEN A DATABASE:

        Syn:

                use <dbname>

        Ex:

                use book

2.TO CLOSE THE DATABASE:

         Use

               To close the current opened database.

        Close all

               To close the all opened database.

3. To CREATE NEW DATABASE:

Syn:
                crea <dbname>   

                create <dbname>

Ex:

                crea book

4. To Modify Structure of the Database:

        Modify structure

                        (Or)

            Modi stru

5. To add new records in database

 Append is used to add the new record.

Syn:

          append

                       [Blank]

                       [From <dbname>]

Ex

Append  
Append Blank
- To add blank records.
Append from first.dbf
- To add the records from FIRST.DBF to SECOND.DBF
- Same Structure is required for these databases

6. To display the records in the current database 

 Used to display the particular record.

 Syn:

  Display

              [All]

              [Structure]

              [Status]

              [Memory]

Ex:

Display      
Display All          
Display All Records in page wise.

7. To Display the structure of the database:

Display Structure     

8. To display the status of the set commands:

Display Status

9. To display the status of the system memory variables.

Display Memory

10. To view the status bar

Set stat on

11. To edit records

EDIT

- It list all the records one by one for editing.

Any one of the record can be edited using 'FOR' as below

EDIT FOR empname = "LEELA"

EDIT FOR rollno = 103

12. To delete records

DELETE

- To delete current record

DELETE NEXT 4

- To delete next 4 records

After using the delete command the records marked with * (asterisk) mark, i.e., marked for deletion.

RECALL

- It is used to recover the deleted records.

e.g. RECALL

RECALL NEXT 4

PACK

- To delete the records permanently. It is used after the delete command.

BLANK

- It can be used to empty the record instead of deleting.

13. To delete all the records in the current database

ZAP