Senin, 31 Oktober 2011

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

0 komentar:

Posting Komentar

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More