Chapter 9: Sub Procedures

Overview

In the previous chapter we put a lot of pieces together. You learned how to connect the code with the database by getting your first look at ADO. In addition, you got some experience in implementing objects.

Up to this point, we have used procedures. However, we have not taken a close look at the mechanics and options available with procedures. In this chapter we are going to concentrate on the mechanics of building a procedure. You will learn the various ways to declare and run a procedure, the various ways arguments can be passed, and the meaning of the word “scope.” You will also learn the differences between sub procedures and functions.

Finally, we will continue to build on the previous chapter by finding various ways to connect with the database.