Foxpro for DOS

• FoxPro is the SEMI-RDBMS

COMMANDS IN FOXPRO

In foxpro first four characters of any command is enough to execute

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

TO OPEN THE DATABASE:

        Syn:

                use <dbname>

        Ex:

                use book

 TO CLOSE THE DATABASE:

         Use

               To close the current opened database.

        Close all

               To close the all opened database.

 TO Create New DATABASE:

Syn:
                crea <dbname>   

                create <dbname>

Ex:

                crea book

Modify Structure:

        Modify structure

                        (Or)

            Modi stru

APPEND

 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

DISPLAY

 Used to display the particular record.

 Syn:

  Display

              [All]

              [Structure]

              [Status]

              [Memory]

Ex:

Display      
Display All          
Display All Records in page wise.

To Display the structure of the databases:

Display Structure     

To display the status of the set commands.
Display Status

To display the status of the system memory variables.

Display Memory

To view the status bar

Set stat on

To edit the current Record

Edit  

GO TOP

Used to move the record pointer at the first record.

GO BOTTOM:

Used to move the record point at the last record.

Go

To go to a particular record

Syn:- GO <recordno>

Eg:- GO 8

Go to record 8

List

Used to list the records.

Syn:

list