Work Area and Alias Name

Before discussing the work area and the name of an alias on the USE instruction, then it will be discussed in advance the understanding of each

Work Area is a part of a predetermined memory for storing data in a database file. In professional foxbase LAN, the user / programming can enable the database files in 10 work areas chosen. The work area is marked with the letters A - J or with numbers 1 -10.

At the beginning of time, then the selected work area is the working area 1 or A. To activate a selected work area to use instructions
SELECT<work area : alias>

In relation to the alias database file is given a different name for the database file for purposes of manipulation or programming. By the time a database fie formed, then the alias will automatically be given the same name with the name of the database file.

In relation with instruction SELECT, then the alias name of a database file can be used to select the work area
Example :
SELECT 1 Or SELECT A

In relation with instruction in above :
SELECT 1
USE scmaster
Or
SELECT scmaster
USE scmaster
OR
USE SCMASTER IN 3

Ex ALIAS in reltion with instruction USE :
USE SCMASTER alias name IN 3

If the work area that is actively working one, and the desired access CD_PRD field in the work area 3, then use a command like this:
SCMASTER>cd_prd
Or
C->cd_prd
Or
C.cd_prd
Or
SCMASTER.cd_prd

In relation to the variable memory, a variable memory alias is used to distinguish between the field name with the name of the memory variable
Ex :
field name : cd_prd
memory variable name : m-cd_prd or m.cd_prd

A related function is a function with a USE instruction DBF (). These functions are used to find out the name of the database file in the selected area :
Syntax : DBF([<alias>])
Ex :
USE scmaster
?DBF()
c:\foxproln\scmaster.dbf


SELE 3
USE scmaster
SELE 1
?DBF(3)
c:\foxproln\scmaster.dbf

To close a database file, using a USE instruction without any selection. These instructions will only close the database file at that time the work area only, while to shut down all database files on all areas of work, and restore the work area at a working area 1 used instructions CLOSE

Read More

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.

Read More

activate and close the database file

To be able to fill in data in a database file, then the database files must be activated or opened first, the instructions to activate the database file is:
USE[<file database name> : ?]
[IN<work area>]
[INDEX<list file index  name>]
[ALIAS<alias name>]
[NOUPDATE]
Description:

• <file name database> is the name of the database file to be switched 
• choice? : Used to activate the database file by QUERY
• Option [IN<work area>]  option to open the database file in the working area of ​​the intended to
• [INDEX<list file index  name>] include once the file index (selected) for the activated.
•  [ALIAS<alias name>] option for given name alias
• [NOUPDATE] prevent the activated database has not changed

Read More