It usually difficult to view a number of records on the screen at the same time. ?Date() command displays the current date (mm / dd /yy) The Set Print command sends output to the printer in addition to the screen. Set Headings on command displays the records with field headings. Set Headings off command displays the record without the field headings. For example, using the command, go 6 Display we can display the 6 th record.ĭisp all stuno, stuname, fees displays all the field names.ĭisp all stuno for course = “FoxPro” displays the number of students in foxpro course. The default scope of the Display command is current record position. Both commands display the list of the records in the table. Display All and List command are interchangeable. LIST for doj> displays data of students joined after the specified date of joining (doj).ĭisplay command is somewhat similar to LIST command. Here note that the character names are unique as in data. LIST for stuname = “Raghu” and Fees >200 displays the data for Raghu if the fee is greater than 200. LIST for Fees > 2450 and “rao” displays data except rao’s. LIST for Fees > 2450 displays the fees greater than the amount 2450. Note: Val is used for the conversion of characters into numeric.

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