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

Make A file database

for create database use the syintax CREATE
Ex : CREATE [<database name> : ?]
Where :

• <database name> is a file name and should be given to the file rule of give the name equal to given to name on DOS.
• Option ? used to select the name of the database file based on a list of file names that have been there before 

Type is CREATE scmaster on the Commmand window and then in the display will see another window, the next input field name for the first ex : Cd_prd then enter RETRUN, it will move the next field, type field type in C to give a character-type field, then the cursor will move to the third field, the width field, then type the 6, then the cursor will move to the next field name.

Note that the structure of the data in a database always consists Fielding:
Field Name
Type Field
field width
decimal field (option for type numeric or float)

Rules of ama field, not more than 10 characters, including spaces and not punctuation is not allowed diapakai to begin a field name.

Examples of the correct name
prd_name
product
category1

Read More