Download user manual ncsu concrete materials database program

The columns we want to display:
W_C_RATIO, CUR_TM, CHEMI_TP, STRGTH_TSTrP, ULT_STRSl
.
The where clause:
W C RATIO< =0.4 AND CUR TM---28 AND AGE TST=28 AND
STRGTH TSTrP='FC'
m
The order clause:
LILT STRS1
Notice that the columns displayed do not have to be in the where clause or the order clause.
However, it is advisable to display all relevent columns to make sure the queried result is as
intended.
Steps
1.
Navigate through the Application Menus to the Query Table A and B screen.
2.
Select Optiott#l(Execute Query and Send to a File). By selecting this option, you are
about to enter and execute a query and send the result to a file.
3.
A new menu screen appears on the screen. On this menu screen you are asked to select
one of the six options that matches your query statement. The rule on which option to
select is always as follows: select the option that contains all the fields that are used,
either in the column clause, the where clause, or the order clause. In our example,
select Option#5 (Query involves Table A and Table B).
4.
A help message box and a prompt, Enter values for columns >, appears on the screen.
At this prompt, you are asked to enter the columns that you want to display on the
screen. Enter W_C_RATIO, CUR_TM, CI-IEMI_TP, STRGTI-I_TSTrP, ULT_STRS 1,
then press < Enter >.
5.
Another help message box and a differentprompt, Where >, appears on the screen. At
this prompt, you are asked to provide the where clause. Enter
W C RATIO< =0.4
STRGTH TSTrP='FC'
AND
CUR TM=28
AND
AGE TST=28
AND
Be sure you have entered all the information correctly. Do not press <Enter> in
middle of the where clause. The program automatically wraps to the next line.
Different parts of a field name are connected with the underscore, not the dash; the
character strings have to be enclosed with single quotations. At this point, the screen
should resemble the Figure 3-2(a). Press <Enter > to continue.
7