Familiar With Relational Databases

A database is a relational database management system package for data collection problems. This package can connect a single database file that anatara with other database files.

System Configuration FoxBase

In a relational database package generally consists of one disk, where the first disc is disk system, and other disk containing the overlay.

Hardware For Qualification FoxBase Profesional

Here are the minimum hardware requirements needed for installation of LAN FoxBase Professional.

Installation FoxBase Profesional-LAN

Assuming that the operating system used is NOVVEL NetWare LANs (SFT V 2.15) VERSION DEDICATED, then organizing the data on the hard disk after the installation process novvel netware is as follows.

Types Databases

There are several types of known file in the package database, these files have different extensions in accordance with the content and functionality of the file.

Kamis, 27 Oktober 2011

Function And Program

function and program foxbase
The function is a form of computation that has been programmed in advance to be able to provide value if the parameter in this function is given the value.
The procedure is no different with a program, the multiple instructions connected together to achieve certain goals. In pemakaianya, the program consists of several procedures. Usually the location / use the function in the procedure is always different. In the professional lan foxbase there are about 200 functions that are ready for use, eg absolute function with the following syntax :



ABS(expN>)
Where : ABS is ABSOLUT function and expN ia parameter.

Example :
? ABS(-34)
34
? ABS(34-76)
42

In addition to the functions that ready-made, professional foxbase-LAN also allows programming lan create a function for a particular purpose. Such functions are called user-defined function (UDF).

examples of the formation function CENTRE.

FUNCTION Centre
* Syntax : Centre (<expC>,<expN>)
*
PRIVATE string, width
PARAMETER string, width
IF LEN(string) >= width
RETRUN(string)
ENDIF
RETRUN SPACE(int(width/2) - INT(LEN(string/2) + string


examples of the formation function PROF_MGN

FUNCTION prof_mgn
* syntax prof_mgn(<expN1>,<expN2>)
*
PARAMETER cost.price
margin = ROUND((price-cost)/price*100.1)
RETRUN margin

Example a PROSEDUR

* Program COBA.PRG
*
SET TALK OFF
CLEAR
PUBLIC k,l
x=5
y=6
z=7
DO TAMBAH
DO KALI
? k
? l
*
PROC TAMBAH
k = x+y+z
RETRUN
*
1 = x+y+z
RETRUN

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More