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

Chapter 14.  Working with SQL Server Dat... > Pass Parameters to Stored Procedures...

14.6. Pass Parameters to Stored Procedures from an ADP

14.6.1. Problem

You have a form that is based on a stored procedure. How do you pass parameter values from a combo box to the stored procedure?

14.6.2. Solution

The InputParameters property allows you to pass parameters to the form's record source. The InputParameters property can be used with stored procedures or with direct Transact-SQL statements. If you use the InputParameters property with a SQL statement, you must formulate the SQL statement with a question mark as the parameter placeholder:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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