Purpose:

This laboratory provides some experience working with the C++ programming language that has an SQL query and SQL update embedded in it.

Procedure:

Follow all the procedures in lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx prior to performing the procedure below.

Be sure to load the C++ to ProQueryExample code presented in the Appendix A of lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx.

1. Be sure to select a Visual C++ Project Type. Also select a Win32 Console Application Template
(step 6 in lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx.)

Enter the name ProQuery for the project (step 7).

2. Once you have started your source code, be sure to add the include files and the library files as indicated in my Oracle Access in C++ in ECET-450 document.

This should have been done in lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx

3. In the Solution Explorer, insert the source code from the ProQueryExample.cpp file into the ProQuery.cpp file to add the needed C++ code. You will want to use most of the classroom code as is. However, you need to modify the code so that you list the sales representative's last names, each of their customer's balances, and each of their customer's names in this order. Be sure to update the column headings. Update the spacing between columns if necessary.

This is also done in lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx

4. In your ProQuery.cpp source file, modify the source code so that it changes the customer balance of Streaming Direct from $210.40 to $337.26. Rerun the query in step 3 above. Modify the source to return the balance of Streaming Direct to $210.40. Rerun the query in step 3 above. Print out a copy of your output.

5. Submit a cover sheet, a copy of your output, and the source code that you used to obtain it. Follow any additional instructions that your instructor may give you.

Step 4 and 5 are the real lab exercise part. Other steps before that are necessary to set up the lab and should have been done using lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx
Part B:

Purpose:

This laboratory provides some experience working with the C++ programming language that has an SQL insert and an SQL delete embedded in it.

Procedure:

When you have completed Part A, most of the following should have been performed except the name of the project to be entered.

Be sure to have a copy of the C++ to ProInsertExample code presented in the Appendix B of lab07Programmable_Access_to_Oracle_in_the_iLab_System.docx..

1. Select a new project. Be sure to select a Visual C++ Project Type. Also select a Win32 Console Application Template. Create a folder on the F drive on the iLab server. Enter the name ProInsert for the project.

2. Once you have started your source code, be sure to add the include file and the library file as indicated in my Oracle Access in C++ in ECET-450 document.

3. In the Solution Explorer, insert the source code from the ProInsertExample.cpp file into the ProInsert.cpp file to add the needed C++ code. You will want to use most of the classroom code as is. However, you are to modify the code so that you display the contents of the Line table.

4. Display the contents of the Line table before doing the insertion. Modify the member function to insert a new row in the Line table. Add the following row: Invoice number: 42447, product ID: KW114, number ordered: 1, and price: $595.00. Be sure to update the column headings. Update the spacing between columns if necessary.

5. Modify the member function that deletes this new row inserted in step 3 above. Display the contents of the Line table again. Print out a copy of your output that displays the Line table before the insertion, of the Line table after the insertion, and the Line table after the deletion.

6. Submit a cover sheet, a copy of your output, and the source code that you used to obtain it. Follow any additional instructions that your instructor may give you.