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.

Rabu, 26 Oktober 2011

file used on foxbase professional lan

foxbase professional lan

File DATABASE (DBF)
Database file consists of a set of data in relational organizing. each data in a database file called records, where each record may consist of one or several fields are arranged in a relational. The file extension of DBF database files.

File INDEX (IDX)
The contents of the file index is essentially the same as the database file, such as the name of the INDEX, then the contents of this file is a database file that is sorted to certain conditions. The condition was taken from the field or a combination of several fields.

File MEMO (FPT)
This file contains all the information from existing fields notes in the database file. The file name field on the reminder directly provides Professional FoxBase same LAN with the name of the database file. This Extention be named FPT.

File PROGRAM
program file consists of a set of instructions that make up foxbase particular purpose. This file can be created with a text editor.

File TEXT (TXT)
This files contains ASCII text data of this type, the results of instruction execution COPY TO..DELIMITED. TXT extension will be directly added to an ASCII file. This file can also be formed using a text editor.

File BACKUP(BAK)
This files contains before data from text files, program or databases. This files formed automatically every a text files or databases update.


File FORMAT (FMT)
This file made to get the appropriate a display form, usualy the contains is coordinate where can be manipulated. Usualy instruction for used in the File FORMAT is @..SAY.GET

File REPORT (FRX)
This file contains definition a report. Is Meant here is about data to make report, where is located data.

File LABEL (LBX)
This values a definition label, label area, required margin.

File VIEW (VUE)
This file contains Detailed information about the work environment of foxbase Professional LAN.

File REPORT VIEW (FRV)
Detailed information about the current work environment foxbase saved report file format.

File LABEL VIEW (LBV)
Detailed information about the current work environment foxbase saved label file format.

File MEMORY VARIABLE (MEM)
Contains information on all memory variables that have been formed in the construction.

File MACRO (FKY)

File contains a set of macro definitions. that in the mean by the definition of macros is to create a separate 
definition of the outcome rather than a keyboard keystrokes
File WINDOW (WIN)
This file contains the definition of the window. Is easily interpreted as part of the screen that was formed for the purpose of data entry, display an error message, display the menu and so on.
File RESOURCE (FOXUSER.DBF)
Contains items that are used by foxbase, such as location and size of the window, set the colors used, facilities diary or calendar and so on. This file has been created automatically during installation foxbase professionals-LAN.
 File HELP (FOXHELP.DBF And FOXHELP.FPT)
contains information about the help facility provided by a professional LAN foxbase.

File FOXVIEW SCREEN TABLE (FV)
This file contains a table on the establishment of a data entry screen for a professional assistance program foxbase FOXVIEW the LAN. Berisidiantaranya table field names, screen attributes uinstruksi SAY / GET etc.

File MASTER TEMPLATE (GEN)
Resources contains templates that control how the module will be used as templates in the application program aids FOXVIEW / FOXCODE. This file contains the name of the proposed general fole submodules that will be included in the establishment of an application with FOXVIEW / FOXCODE.

File TEMPLATE SUBMODUL (INC)
Contains the actual routine and will be used to form an additional application program through FOXVIEW / FOXCODE. These files will be read during the formation of the application and will be combined into one with MASTER TEMPLATE file as controls.

 COMPILED TEMPLATE (COD)
This file contains a template that has been compiled from TEMPLATE MASTER file. The compilation process itself is done with the program FOXCODE

Insruction On Foxbase Profesional lan

instruction-foxbase-profesional-lan
1. COMMAND
Instructions COMMAND used to after the run programs foxbase profesional LAN, the control will immediately execute the instructions in the COMMAND.
EX : - COMMAND = CLEAR
in the above example, after running foxbase will directly work on CLEAR instructions.

2. EMS
Instruction EMS used to for enable or disable using Extended memory
Instruction EMS expressed in the format EMS = <expN>
In the means that EMS = ON with quantity extende memory = <expN>  Kbytes expressed with multiply 16 Kbytes.
EX : EMS = 384

3. INDEX , LABEL And REPORT
That Instruction used to determine for file index. This function keep data security from hacker or cracker.
Example:
INDEX  = FDX
LABEL = LBL
REPORT = RPT

4. MVARSIZE
This Instruction used to determine memory quantity ( declarated on the Kbytes unit ) provided for character data stored in the memory variable.
Example :
If declarated MVARSIZE = 10 that's mean a long data character maximum is 10 Kbytes

5. MVCOUNT
Instruction MVCOUNT used to determine quantity variable memory which can be formed by Foxbase Profesional LAN. Instruction Value located between the 128 And 3600 memory variable And default value is 256.
Example :
MVCOUNT = 500

6. TIME
Time Instruction is used by Foxbase Professional LAN for make the process of waiting on printers for the first to receiving data. If display message PRINTER NOT READY, which existed at the time this instruction is used as reference to wait while the printer is ready.
Value is variation between 1 And 1000000. For default value is 6000.

7. TMPFILES
Foxbase Professional LAN in processing always make temporary files for quick processing. Instruction TMPFILES used to determine where the location temporary on the disk.

configurations settings

configurations settings foxbase
There are two configuration files that can be formed in a professional setting foxbase-LAN
  • CONFIG file. SYS
    is a system file for configuration. Contain information or instructions yanag will do when the computer is turned on. By providing instruction in CONFIG.SYS, then the default value kmputer system configuration will change. For example to increase / decrease the value of the memory available at the time of the operation of reading or writing, should ditambahakan untuka some drivers enable expanded / extenede memory. Two instructions are very dubutuhkan by professional foxbase LAN in the config.sys file : 
    1. BUFFERS =
      These instructions are used to provide a number of BUFFERS (temporary storage) in the RAM memory, to kemudaian transferred to disk, when the computer is turned on. Larger than BUFFER BLOCK measured in units of memory, approximately 512 bytes. To work well advised to give a value of 20 to 40.
    2. FILES =
      These instructions are used to determine how many files that can be activated and accessed by the operating system and also by professional foxbase LAN. To work well on a professional LAN foxbase fatherly advised to give the value 40.
    How to create a CONFIG.SYS file
    • From the prompt F: \ \> type COPY CON : CONFIG.SYS and press RETURN
    • Successive then type BUFFERS = 30 FILES = 40
    • Press ctrl + z to save the file CONFIG.SYS
  • CONFIG.FP
    This file is a special configuration for professional foxbase-LAN function contents are instructions that specify the initial conditions on the LAN foxbase professional. This is the instruction Beriku tables that may exist in the file CONFIG.FP


Instruction Value Default
COMMAND INSTRUCTION -
EMS ON:OFF: ON
INDEX IDX
LABEL LBX
MVARSIZE 1-64 6
MVCOUNT 128 - 3600 256
REPORT FRX
TEDIT editor program -
TIME 1 - 1000000 600
TMPFILES (DRIVE:) -
WP editor program -
SET (syntax set) -

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More