To delete recordsDELETE- To delete current recordDELETE NEXT 4- To delete next 4 recordsAfter using the delete command the records marked with * (asterisk) mark, i.e., marked for deletion.RECALL To edit recordsEDIT- It list all the records one by one for editing.Any one of the record can be edited using 'FOR' as belowEDIT FOR empname 'LEELA'EDIT FOR rollno 10312.

To display the status of the system memory variables.Display Memory10. To display the status of the set commands:Display Status9. To Display the structure of the database:Display Structure8. To display the records in the current databaseUsed to display the particular record.Syn:DisplayД®x:DisplayDisplay AllDisplay All Records in page wise.7.

To add new records in databaseAppend is used to add the new record.Syn:appendExAppendAppend 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 databases6. To Modify Structure of the Database:Modify structure(Or)Modi stru5.

To CREATE NEW DATABASE:Syn:crea dbname create dbname Ex:crea bookД¤. TO OPEN A DATABASE:Syn:use dbname Ex:use book2.TO CLOSE THE DATABASE:UseTo close the current opened database.Close allTo close the all opened database.3. Hence, the single table is called as database in this tutorialIn FoxPro, first four characters of any command is enough to executeFor e.g.:- crea create1. Foxpro for MS-DOS - Basic FoxPro 2.6 Commands FoxPro is SEMI-RDBMS Unlike other RDBMS systems, in FoxPro each database can contain only one table.

Foxpro 2.6 fcreate