Replace commandTo replace the content of the specified field in the database table. ?DATE()To set century on to display year in 4 digits.SET CENTURY ONSET CENTURY OFFTo set date formatdd/mm/yyyy SET DATE BRITmm/dd/yyy SET DATE AMERICAyyyy/mm/dd SET DATE JAPAN22.
Handling date and date formatTo display current system date PrintingSET PRINT ON- This command sends the out put to printer- To stop this use the command SET PRINT OFFSET PRINTER TO LPT1- To set the output printing port to LPT121. Hide or Show heading in list viewSET HEADINGS OFFSET HEADINGS ON20. To display the dbf files in the current directoryDIR19. To display current record number?RECNO()18. To view the records as manipulatable viewBROWSE - To browse the recordsBROWSE NOEDIT - To browse the records in read only view, The records can be marked for deletionusing Ctrl T shortcutBROWSE NODELETE - To avoid deleting while browsing the records17. The changes are applied only to the view, itnot saved in database.LIST product, price*2- price is multiplied with 2.16. LIST itemname, price 20- This command lists item name with price rupees 20 added. To List the recordsLIST - To list the records in screen, not in windowIt can be used with condition as below:LIST for val(price) 100 Navigation with RecordsGO or GOTO both do the same things in Foxpro.GO TOPUsed to move the record pointer at the first record.GO BOTTOM:Used to move the record point at the last record.GoTo go to a particular recordSyn:- GO recordno Eg:- GO 8Go to record 8SKIP- To skip number of recordse.g.
To delete all the records in the current databaseZAP14. It is used after the delete command.BLANK- It can be used to empty the record instead of deleting.13.
RECALLRECALL NEXT 4PACK- To delete the records permanently. It is used to recover the deleted records.e.g. 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.