To blank some or all the fields in the current record. REPLACE ALL PRICE WITH PRICE+50 - Adds 50 to the price field. REPLACE ALL QUANTITY WITH 0 - Replaces the data in the quatity fied with 0 in all the records. REPLACE fieldname WITH '' - To replace with null value REPLACE fieldname WITH - To replace the date field with null value i.e., This command can be used to remove the data in the particular field (nullifying / empty a field) e.g. To replace the content of the specified field in the database table. SET CENTURY ON SET CENTURY OFF To set date format dd/mm/yyyy => SET DATE BRIT mm/dd/yyy => SET DATE AMERICA yyyy/mm/dd => SET DATE JAPAN ?DATE() To set century on to display year in 4 digits. SET PRINT ON - This command sends the out put to printer - To stop this use the command SET PRINT OFF SET PRINTER TO LPT1 - To set the output printing port to LPT1 To display the dbf files in the current directory To view the records as manipulatable viewД«ROWSE - To browse the records BROWSE NOEDIT - To browse the records in read only view, The records can be marked for deletion using Ctrl + T shortcut BROWSE NODELETE - To avoid deleting while browsing the recordsДЎ8. LIST product, price*2 - price is multiplied with 2.ДЎ6. The changes are applied only to the view, it not saved in database. LIST itemname, price+20 - This command lists item name with price rupees 20 added. LIST - To list the records in screen, not in window It can be used with condition as below: LIST for val(price) > 100 Go To go to a particular record Syn:- GO Eg:- GO 8 Go to record 8 SKIP - To skip number of records e.g. GO BOTTOM: Used to move the record point at the last record.

GO TOP Used to move the record pointer at the first record. GO or GOTO both do the same things in Foxpro. To delete all the records in the current database ZAP BLANK - It can be used to empty the record instead of deleting. RECALL RECALL NEXT 4 PACK - To delete the records permanently. It is used to recover the deleted records. 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. Any one of the record can be edited using 'FOR' as below EDIT FOR empname = 'LEELA' EDIT FOR rollno = 103ДЎ2. To edit records EDIT - It list all the records one by one for editing. To display the status of the system memory variables. To display the status of the set commands: Display Status 9.

To Display the structure of the database: Display Structure 8. Ex: Display Display All Display All Records in page wise. To display the records in the current database Used to display the particular record.

Append from first.dbf - To add the records from FIRST.DBF to SECOND.DBF - Same Structure is required for these databasesД¦. Syn: append Ex Append Append Blank - To add blank records.

To add new records in database Append is used to add the new record. To Modify Structure of the Database: Modify structure (Or) Modi stru 5. To CREATE NEW DATABASE: Syn: crea create Ex: crea bookД¤. Close all To close the all opened database. TO OPEN A DATABASE: Syn: use Ex: use book 2.TO CLOSE THE DATABASE: Use To close the current opened database. In FoxPro, first four characters of any command is enough to execute For e.g.:- crea => create 1. Hence, the single table is called as database in this tutorial Foxpro for MS-DOS - Basic FoxPro 2.6 CommandsДЇoxPro is SEMI-RDBMS Unlike other RDBMS systems, in FoxPro each database can contain only one table.

Foxpro 2.6 commands with example