LIST stuname, Fee -50 displays the figures deducting 50 from previous amount. –> LIST stuname, Fee +50 displays the figures of student name adding 50 to the previous amount. –> LIST stuno, stuname, fee (field name) displays the said field names only. The scope can be changed by using various options of the list command. The default scope of the List command is to display all the record on the screen. Data can be viewed with the list and display command with the command window. To modify data in the existing records the following commands can be used: –> EDIT displays the required record to be edited on the screen.ĮDIT fields stuno, stuname, fee: displays the above fields on the screen.Īfter adding the record to the table, the next logical step is to view the data.

? RECNO() command displays the current record number.

Skip -2 goes back to 2 records, that is current record – 2. Go Bottom moves the record pointer on last record.Ĭommand moves the record pointer from the current location to next location. Go Top command moves the record pointer on first record.

Go 2 command is used to show the positioning of the record pointer on the 2nd record. A table first opens the Record Pointer normally pointing the first record in the table. Dir command displays the database file.įoxPro marks its position with a table by means of a internal maker called the record pointer. Set carry off command is used to delete or to stop duplication. Set carry on specifies static enter or duplicate for the present record into a new record when the append command is entered.

Set default to A is used to change the default root directory from C: drive to A: drive.

And the command used to close the status bar is It shows the screen active database file, the current record pointer position, number of records in the database file. Set status on displays status bar at the bottom of the screen. Here is brief overview and example usage of the basic FoxPro commands like Append, Set, Record, Go to, Skip, Edit, List, Display, Browse and Replace.Īppend command is used to add new record in the table.

Foxpro 2.6 commands with example