Datasheet

54
Data Retrieval, Processing and Final Storage in the Nile Basin Database
The view shown above is called “Query 1: Select Query”. It is in this view where the user has to select/design a
query which will look into the specified database table and select the data records targeted for transfer/exchange.
Step E5: Proceed and double click on each of the field names displayed in the small window (with the name of the
queried table displayed on its top) located in the upper left corner of the above view; in our illustrative example the
name of the queried table is “AWS Meteo_Daily Data” (shown on the top of the small window) and the field names to
double click are “Station-ID”, “Date”, “Source”, “Avg_T” and so on.
The result of this operation is illustrated on the screen shown below:
The next to do is to use “Criteria” field (located in the lower part of the above view) to specify the NBD Station IDs
and the time period (i.e. the begin and end dates) written down under the Step E1.
Step E6: First specify the station IDs by clicking in the “Criteria” cell under “Station-ID” and type the selected sta-
tion ID. Then proceed and specify the begin and the end dates of the time period of interest by clicking the “Criteria”
cell under “Date” and by typing the following or similar text “between#01-Jul-98#and#30-Jul-98#” in the cell;
depending on the specific time period for which the data records are to be extracted from the main database table.
The result of Step E6 is illustrated below:
Exchange of NBD Data with other users