To test SkyWriteApp for the Flights table, you're going to modify data using FlightForm, and then print a flight schedule on the screen.
Editing Flight Information
The Modify Flight option on the Flights menu works differently than the modify options on the Employees and Customer menus. The action is defined to edit data based on FlightDate. Let's look at and modify a row in the Flights table.
To change data about a scheduled flight:
| 1. | In the SkyWriteApp application, choose Flights: Modify Flight. |
The process now differs from that for the Employees and Customers menus. R:BASE prompts you for the flight date. Enter the beginning date for the records you want to view.
| 2. | For the flight date, enter "06/03/2022". |
| 3. | Click the OK button. |
The flight form, FlightForm, is displayed.
R:BASE retrieves all rows from the Flights table where the date is greater than or equal to June 3, 2022. The first row of data that equals or follows the specified date appears on the screen. This row is for the customer Nicki Jambour.
Now, let's scroll through the rows.
| 4. | Choose the green right arrow button, which displays the hint "Next". |
Another row for Performance Specialists is displayed.
| 5. | Choose the green right arrow button again. |
The third row of data that equals or follows the specified date is displayed. This row is for Aquaculture Gems, Inc. This customer had changed the skywriting time from noon to 2 pm.
| 6. | Click in "Location/Time" and change the time. |
| 7. | Choose the check mark button to save the changes when you have finished. |
We've just modified and saved this row.
Exit the form, by clicking the "Close" button, after you make the change.
Printing the Flight Schedule
Now you can print the Scheduled Flights report.
To print the list of scheduled flights:
| 1. | In the SkyWriteApp application, choose Flights: Print Flight Schedule. |
| 2. | Enter June 3, 2022 as the flight date to review. |
| 3. | When you are done viewing the data, press the "Close" button to clear the report from the screen. |
