Posted by admin in General | 0 Comments
DataBase Management for Computer
DataBase Management In the management database. Many computer programs. Convenience. To access the selective information. And stored in different linguistic communications such as Pascal, ATOMIC NUMBER 6 language, but STAPLE computer programme. That is accepted and wide used software package is a set of FoxPro database management programs are effective.
To deal with high database. The program can Operates in the interface and can be used at once to users. Developed by the drug user itself. The tools of writing. Program itself. This allows for easier coating development.
Setup Application.
Because of the FoxPro software package is a large programme and is available in both systems on DOS and on Windows, but for a novice coder should be chosen on a set of FoxPro DOS programme to canvas the various commands to empathise as far as possible. For DOS on the FoxPro software package is available in several interlingual rendition but the interlingual rendition that is wide used in the current interlingual rendition 2.6 for DOS or known in the name of sub-directory FPD26 which to instal the package. If any lector CD ROM is easy. By the CD ROM with a suite Foxpro (or FPD26) and instal it into the machine. The program will put in the data files necessitated to complete the package. This will ordinarily make sub-directory FPD26 up mechanically. Shall complete the installation.
How to Use.
To utilise the FoxPro software package, users must have knowledge of database management programs such as dBASE or FoxBase before, or if no such anterior knowledge. I call for to meditate whether self-study. Or learn from any educational institutions because of the FoxPro software package is used throughout the world. Master’s programme is in English.
So if a user needs to store the info to English. To find out computer programmes in Thai Resident Program is to put in before using FoxPro software package by looking into the following set of commands.
cd fpd26.
C : FPD26) thai.
ATOMIC NUMBER 6 : FPD26) fox.
After that, then. Able to check all the packages Foxpro.
Make Structure.
To make a data file complex body part database. Start out by using the commands in the instruction frame. By typewriting the following instruction.
create .
in the bailiwicks of the database computer file name. Suppose that a student can cite the single file instruction is make student.
Then able to shape items about the file complex body part such a database.
- The name of the field (Field name).
- Type of informations (Type).
- Breadth (Breadth).
- Number of decimal spaces, etc. (Decimal).
When the complete social structure of the database data file. Can be saved by pressing the pursuit.
Ctrl W or Ctrl End.
Body structure of the database data file. Is stored in a single file and the type of student is a dbf single file mechanically.
Append and Edit.
Add and redact informations. Of info is stored in the database data files. The first to open the file first. By using the following instruction.
Use student.
After adding the data. This opens up a new record to have more information in the database data file using the instruction.
append.
If you want to redact living informations in the data file, then. It is no more informations to the database data file can use the instruction.
edit.
To ameliorate informations accuracy. And create data files more complete informations base.
elete Recall and Reputation.
For info on any database single file, each record is reckoned as one point if the listing does not want to appear in the database file. Can exhibit the hidden by Command used to exhibit the following hiding.
Delete.
The utilization of this instruction, the item will be marked before of the hidden record, but if you do not want that point in the database file in the least. Can utilise the instruction.
pack.
Items with a hidden marking will be taken from the file. And other items will be a new rather record is less than the original.
On the other hand, while the print that shows the hidden. To obliterate the marks evaporate. To show that point as the same can be done by the instruction.
recall.
Particulars that are marked as hidden. Will be terminated immediately obliterate. And to show the informations down to the inclination. Program lines that exhibit info most easily.
Listing or video display.
If you want to redact with. While the informations showing that Can be done by.
browse.
When the show. Browse and blue pencil the informations must be done to save your changes by compacting Ctrl W or Ctrl End.
Index.
Highlights of the programme is the type of database management. Quickly approach to information by package foxPro indicator must be set first with instruction.
- Index on to .
By that.
- An saying which lets in. Same study area. Or a compounding of several landing fields in the area using the compounding.
- is the name of the single file you want to cite the indicator file. This is the type of single file is mechanically idx.
When used in conjunction with the motivation to spread the database file. Assume that the indicator computer file name, the instruction is stdcode.
- Index on computer code to stdcode.
To use it. Must be activated in conjunction with the database indian files such as.
- Use student forefinger stdcode.
Or you can utilise other types.
- Use student.
- Set forefinger to stdcode.
Find.
After making the forefinger file to the database. Database will be sought easily and quick by using the following instruction.
- Find .
The specific grapheme expc FoxPro will find out the first record that jibes the fixed grapheme is like.
- Find A32014.
When searching for mine. Information can be displayed by the instruction.
- List
- Display
- Browse
If the grapheme does not assign the database file. Device is reported as Not Found.
Quit.
At the end of the FoxPro software package so work can be inactivated by typing. Command within the instruction that.
- Quit.
Machine out of the package to FoxPro DOS Prompt same. more info : lyciaproperty.com, How to DataBase Management
