PROCEDURE Clause - Access - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

PROCEDURE Clause

Applies to: Microsoft Office Access 2003

Defines a name and optional parameters for a query.

Note The PROCEDURE clause has been superseded by the PROCEDURE statement. Although the PROCEDURE clause is still supported, the PROCEDURE statement provides a superset of the capability of the PROCEDURE clause and is the recommended syntax.

Syntax

PROCEDURE name [param1 datatype[, param2 datatype[, ...]]

The PROCEDURE clause has these parts:

Part	Description
name	A name for the procedure. It must follow standard naming conventions .
param1, param2	One or more field names or parameters . For example: `PROCEDURE Sales_By_Country [Beginning Date] DateTime, [Ending Date] DateTime;`
datatype	One of the primary Microsoft Jet SQL data types or their synonyms.

Remarks

An SQL procedure consists of a PROCEDURE clause (which specifies the name of the procedure), an optional list of parameter definitions, and a single SQL statement . For example, the procedure Get_Part_Number might run a query that retrieves a specified part number.

Notes

If the clause includes more than one field definition (that is, param-datatype pairs), separate them with commas.
The PROCEDURE clause must be followed by an SQL statement (for example, a SELECT or UPDATE statement).

Syntax

Remarks

See Also