database manipulation

is manipulated here is how to add / income data, change data, view data, delete data in a database file.

Add and Change data
on a LAN there are 5 professional foxbase instructions that can are used to add data, respectively

• APPEND
• BROWSE
• EDIT
• INSERT
• CHANGE

APPEND instruction, commonly used to add data in dalama a program, while the instruction BROWSE, EDIT, INSERT and CHANGE is used to add data with QUERY mode.

1. Add data with instruction APPEND

Instruction and syntax APPEND is below:
APPEND[BLANK]
For add data on database file SCMASTER.DBF

USE scmaster

APPEND

Then the screen should look a window to another, to enter data. The data entry can be done by typing the existing data in each field are available. To move from one field to the next field, press the retrun, or if the data length equals the length of the field provided, then it will automatically move to the next field.

Posted in: Foxbase Database,foxbase multi user,Foxbase professional LAN,function and program