Viewing Successful Results

If a statement other than a query completes successfully, a message appears at the bottom of the screen. For the statement that Figure 11 shows, the following message appears:

Table created.

If you use the Run option with a SELECT statement and that SELECT statement runs correctly, DB–Access displays the requested results below the header. If your query retrieves more rows than can fit on a single screen, the results screen has a menu at the top, as Figure 12 shows.

RUN:   Next  Restart Exit
Display the next page of query results.

------------------ mystores@dbserver1 -------------- Press CTRL-W for Help ------

customer_num  106
call_dtime    1997-06-12 08:20
user_id       maryj
call_code     D
call_descr    Order was received, but two of the cans of ANZ tennis balls within
              the case were empty
res_dtime     1997-06-12 08:25
res_descr     Authorized credit for two cans to customer, issued apology. Called 
              ANZ buyer to report the QA problem.

customer_num  110
call_dtime    1997-07-07 10:24
user_id       richc
call_code     L
call_descr    Order placed one month ago (6/7) not received.
res_dtime     1997-07-07 10:30
res_descr     Checked with shipping (Ed Smith). Order sent yesterday- we were 
            waiting for goods from ANZ. Next time will call with delay if 
              necessary.

Advance through the output as follows:

• With the Next option highlighted, press RETURN to advance the display through the selected rows. The last screen of data has a message at the bottom that indicates the number of rows that the query returned.
• Select Restart to return to the first screen of query output.
• Select Exit to exit the output display and return to the SQL menu. If you exit before you reach the last output screen, a message at the bottom of the screen indicates that you interrupted the query.