Posted by admin in General | 0 Comments
DataBase Management for Computer
DataBase Management In the management database. Many computer programs. Convenience. To get at the entropy. And stored in different linguistic communications such as Pascal, ATOMIC NUMBER 6 linguistic communication, but STAPLE computer programme. That is accepted and widely used software package is a set of FoxPro database management programmes are effective.
To handle with high database. The computer programme can Operates in the user interface and can be used directly to users. Developed by the user itself. The tools of writing. Program itself. This allows for easier application development.
Setup Application.
Because of the FoxPro software package is a large programme and is available in both systems on Department of State and on Windows, but for a initiate software engineer should be chosen on a set of FoxPro DOS programme to canvas the versatile program lines to understand as far as possible. For Department of State on the FoxPro software package is available in several version but the version that is widely used in the current version 2.6 for Department of State or known in the name of sub-directory FPD26 which to install the package. If any reader CD ROM is easy. By the CD ROM with a suite Foxpro (or FPD26) and install it into the motorcar. The computer programme will set up the files called for to complete the package. This will usually make sub-directory FPD26 up automatically. Shall finish the induction.
How to Use.
To utilize the FoxPro software package, users must have noesis of database management programmes such as dBASE or FoxBase before, or if no such prior noesis. I involve to study whether self-study. Or instruct 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 wants to store the information to English. To find out programmes in Thai Resident Program is to set up before utilising FoxPro software package by looking into the pursuing set of program lines.
cd fpd26.
C : FPD26) thai.
ATOMIC NUMBER 6 : FPD26) fox.
After that, then. Able to find out all the packages Foxpro.
Make Structure.
To make a data file structure database. Commence by utilising the commands in the command frame. By typewriting the pursuing command.
create .
in the subjects of the database filename. Say that a bookman can refer the single file command is make bookman.
Then able to regulate details about the file structure such a database.
- The name of the field (Field name).
- Type of datas (Type).
- Width (Width).
- Number of denary spaces, etc. (Decimal).
When the complete social system of the database data file. Can be preserved by urging the chase.
Ctrl W or Ctrl End.
Complex body part of the database data file. Is stored in a single file and the character of bookman is a dbf single file automatically.
Append and Edit.
Add and redact datas. Of information is stored in the database files. The first to open the file first. By utilising the pursuing command.
Use bookman.
After adding the data. This opens up a new record to have more information in the database data file using the command.
append.
If you desire to redact subsisting datas in the data file, then. It is no more datas to the database data file can use the command.
edit.
To amend datas accuracy. And make files more consummate datas base.
elete Recall and Reputation.
For information on any database single file, each record is seen as one item if the listing does not desire to appear in the database file. Can exhibit the hidden by Command used to exhibit the following hiding.
Delete.
The employment of this command, the token will be marked ahead of the hidden record, but if you do not desire that item in the database file at all. Can utilize the command.
pack.
Points with a hidden marker will be taken away from the file. And other tokens will be a new kinda record is less than the original.
Then again, while the print that shows the hidden. To hide the marks melt. To show that item as the same can be done by the command.
recall.
Particulars that are marked as hidden. Will be terminated immediately hide. And to show the datas down to the tilt. Program lines that exhibit information most easily.
List or video display.
If you desire to redact with. While the datas showing that Can be done by.
browse.
When the show. Browse and delete the datas must be done to preserve your changes by squeezing Ctrl W or Ctrl End.
Index.
Highlightings of the programme is the type of database management. Promptly approach to information by package foxPro index must be set first with command.
- Index on to .
By that.
- An saying which admits. Same discipline expanse. Or a compounding of several fields in the expanse utilising the compounding.
- is the epithet of the single file you want to refer the index file. This is the character of single file is automatically idx.
When used in conjunction with the motive to spread out the database file. Seize that the index filename, the command is stdcode.
- Index on code to stdcode.
To use it. Must be activated in conjunction with the database single files such as.
- Use bookman forefinger stdcode.
Or you can utilize other types.
- Use bookman.
- Set forefinger to stdcode.
Find.
After making the forefinger file to the database. Database will be sought easy and quick by using the pursuing command.
- Find .
The specific character expc FoxPro will find out the first record that corresponds the determined character is like.
- Find A32014.
When looking for for mine. Data can be displayed by the command.
- List
- Display
- Browse
If the character does not set apart the database file. Device is reported as Not Found.
Quit.
At the terminal of the FoxPro software package so work can be deactivated by typecasting. Command within the command that.
- Quit.
Machine out of the package to FoxPro DOS Prompt same. more info : lyciaproperty.com, Information DataBase Management
