Modify Structure: Modify structure (Or) Modi struAPPENDAppend is used to add the new record.Syn: append ExAppendAppend 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 databasesDISPLAYUsed to display the particular record.Syn: Display Ex:DisplayDisplay AllDisplay All Records in page wise.To Display the structure of the databases:Display StructureTo display the status of the set commands.Display StatusTo display the status of the system memory variables.Display MemoryTo view the status barSet stat onTo edit the current RecordEdit 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 Eg:- GO 8Go to record 8ListUsed to list the records.Syn:list Close all To close the all opened database.TO Create New DATABASE:Syn: crea create Ex: crea book

COMMANDS IN FOXPROIn foxpro first four characters of any command is enough to executeFor e.g.:-crea=>createTO OPEN THE DATABASE: Syn: use Ex: use bookTO CLOSE THE DATABASE: Use To close the current opened database.

Foxpro 2.6 commands with example