DataBase Management In the management database. Many computer programs. Convenience. To get at the selective information. And stored in different linguistic communications such as Pascal, CARBON linguistic communication, but BASIC program. That is accepted and wide used software package is a set of FoxPro database management programmes are effective.
To deal with high database. The programme can Operates in the interface and can be used instantly to drug users. Developed by the user itself. The tools of writing. Program itself. This allows for easier covering development.
Apparatus Application.
Because of the FoxPro software package is a big program and is available in both systems on DOS and on Windows, but for a novice coder should be picked out on a set of FoxPro DOS program to study the various statements to understand as much as possible. For DOS on the FoxPro software package is available in several rendering but the rendering that is wide used in the current rendering 2.6 for DOS or known in the name of sub-directory FPD26 which to instal the package. If any reader CD ROM is easy. By the CD ROM with a suite Foxpro (or FPD26) and instal it into the motorcar. The programme will put in the files asked to complete the package. This will normally make sub-directory FPD26 up automatically. Shall complete the installation.
How to Use.
To utilise the FoxPro software package, users must have noesis of database management programmes such as dBASE or FoxBase ahead, or if no such prior noesis. I need to contemplate whether self-study. Or instruct from any educational institutions because of the FoxPro software package is used throughout the world. Master’s program is in English.
So if a user wants to store the info to English. To ascertain programmes in Thai Resident Program is to put in before utilizing FoxPro software package by looking into the following set of statements.
cd fpd26.
C : FPD26) thai.
CARBON : FPD26) fox.
After that, then. Able to learn all the packages Foxpro.
Make Structure.
To make a file body structure database. Start out by utilizing the commands in the statement frame. By typing the following statement.
create .
in the disciplines of the database filename. Say that a scholar can name the file statement is make scholar.
Then able to influence points about the file body structure such a database.
- The name of the landing field (Field name).
- Type of informations (Type).
- Width (Width).
- Number of decimal blank spaces, etc. (Decimal).
When the complete social system of the database file. Can be preserved by urging on the following.
Ctrl W or Ctrl End.
Structure of the database file. Is stored in a file and the eccentric of scholar is a dbf file automatically.
Append and Edit.
Add and edit informations. Of info is stored in the database files. The first to open up the file first of all. By utilizing the following statement.
Exercise scholar.
After adding the data. This opens up a new record to have more information in the database file using the statement.
append.
If you want to edit surviving informations in the file, then. It is no more informations to the database file can use the statement.
edit.
To ameliorate informations accuracy. And create files more consummate informations base.
elete Recall and Reputation.
For info on any database file, each record is seen as one point if the listing does not want to appear in the database file. Can expose the hidden by Command used to expose the following hiding.
Delete.
The usage of this statement, the item will be marked in front of the hidden record, but if you do not want that point in the database file the least bit. Can utilise the statement.
pack.
Points with a hidden marking will be taken away from the file. And other items will be a new sort of record is less than the original.
But then, while the mark that shows the obscured. To blot out the marks evaporate. To show that point as the same can be done by the statement.
recall.
Items that are marked as obscured. Will be ended immediately blot out. And to show the informations down to the list. Statements that expose info most easily.
Listing or video display.
If you want to edit 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 squeezing Ctrl W or Ctrl End.
Index.
Highlights of the program is the type of database management. Quick access to information by package foxPro indicant must be determined first with statement.
- Index on to .
By that.
- An expression which admits. Same field surface area. Or a combining of several landing fields in the surface area utilizing the combining.
- is the epithet of the file you want to name the indicant file. This is the eccentric of file is automatically idx.
When used in conjunction with the motive to open the database file. Usurp that the indicant filename, the statement is stdcode.
- Index on code to stdcode.
To use it. Must be activated in conjunction with the database files such as.
- Use scholar forefinger stdcode.
Or you can utilise other types.
- Use scholar.
- Set forefinger to stdcode.
Find.
After making the forefinger file to the database. Database will be searched easy and quick by using the following statement.
- Find .
The specific grapheme expc FoxPro will ascertain the first record that corresponds the determined grapheme is like.
- Find A32014.
When searching for mine. Information can be displayed by the statement.
- List
- Display
- Browse
If the grapheme does not assign the database file. Device is reported as Not Found.
Quit.
At the terminal of the FoxPro software package so work can be deactivated by typing. Statement within the statement that.
- Quit.
Machine out of the package to FoxPro DOS Prompt same. more info : lyciaproperty.com, How to DataBase Management