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. Navigation with Records GO or GOTO both do the same things in Foxpro. To delete all the records in the current database ZAP 14. BLANK - It can be used to empty the record instead of deleting. RECALL RECALL NEXT 4 PACK - To delete the records permanently. RECALLĤ - It is used to recover the deleted records. Any one of the record can be edited using 'FOR' as below EDIT FOR empname = "LEELA" EDIT FOR rollno = 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. 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. Syn: Display ģ 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 6. 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.
0 kommentar(er)
