In the next lesson, we will be viewing information in the database. So now we need to add data to the tables that we created.
In the "Tutorial" directory located in the R:BASE 11 default installation folder, C:\RBTI\RBG11\Tutorial\ , there is a file called SKYDATA.BAK. The file contains data for all three tables in SkyWrite, as well as the R:BASE commands needed to load the data into the correct tables. We'll use a command to load the data from the file.
IMPORTANT NOTE: It is likely that the folder where you created the SkyWrite database is not the same folder location where the SKYDATA.BAK file is located. In this case, you are required to copy the SKYDATA.BAK file to your directory where the SkyWrite database exists.
To load the tables in the SkyWrite database:
Choose Tools: R> Prompt... if the "R> Prompt" window is not open.
Enter "RUN SKYDATA.BAK" and press [Enter].
R:BASE displays a series of messages to tell you that data is being loaded into the tables in the SkyWrite database. If you receive an error stating that the file does not exist, refer to the "IMPORTANT NOTE" above.
Now let's check to see that the rows were loaded into their tables.
Enter "LIST" and press [Enter].
R:BASE lists the tables in the database. Check to make sure that there are 7 rows of data in the Employee table, 15 rows in Customer, and 28 rows in Flights.