• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Building Unbound Application... > The Unbound Form and Stored Procedur...

The Unbound Form and Stored Procedures

My favorite technique with unbound forms is to use stored procedures to retrieve, insert, update, and delete data. Whereas the first two techniques covered in this chapter include the SQL statements required to manipulate the data, the code in this section simply executes stored procedures that retrieve, insert, update, and delete the data. The process of using stored procedures has the following benefits:

  • Stored procedures help you to separate the client application from the structure of the database.

  • Stored procedures help you to simplify client coding.

  • Stored procedures process at the server (reducing required bandwidth).

  • Stored procedures allow you to create reusable code.

  • Stored procedures allow you to perform error handling at the server.

  • Stored procedures facilitate the security of data.

  • Because stored procedures are precompiled, they execute more quickly.

  • Stored procedures improve the stability of the application.

  • Stored procedures reduce network locking.

  • When you build a stored procedure, a query plan is created. This query plan contains the most efficient method of executing the stored procedure given available indexes and so on.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint