A FoxPro command can be executed by typing first character is?
Answers
Answer:
OPEN A DATABASE:
Syn:
use <dbname>
Ex:
use book
2.TO CLOSE THE DATABASE:
Use
To close the current opened database.
Close all
To close the all opened database.
3. To CREATE NEW DATABASE:
Syn:
crea <dbname>
create <dbname>
Ex:
crea book

4. To Modify Structure of the Database:
Modify structure
(Or)
Modi stru
5. To add new records in database
Append is used to add the new record.
Syn:
append
[Blank]
[From <dbname>]
Ex
Append
Append 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 databases
6. To display the records in the current database
Used to display the particular record.
Syn:
Display
[All]
[Structure]
[Status]
[Memory]
Ex:
Display
Display All
Display All Records in page wise.
7. To Display the structure of the database:
Display Structure
8. To display the status of the set commands:
Display Status
9. To display the status of the system memory variables.
Display Memory
10. To view the status bar
Set stat on
11. To edit records
EDIT
- It list all the records one by one for editing.
Any one of the record can be edited using 'FOR' as below
EDIT FOR empname = "LEELA"
EDIT FOR rollno = 103
12. 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.
RECALL
- It is used to recover the deleted records.
e.g. RECALL
RECALL NEXT 4
PACK
- To delete the records permanently. It is used after the delete command.
BLANK
- It can be used to empty the record instead of deleting.
13. To delete all the records in the current database
ZAP