When a program passes data to a procedure or function, the parameters in the procedure or function handles that data so the procedure or function can perform operations on the data. When you want to create procedures and functions that process data that the calling program passes to them, you need to include parameters in the procedure and function definitions.

The following lines of code illustrate the basic format for including parameters in procedure definition:

В	Copy Code
PROCEDURE myProcedure LPARAMETERS Par1, Par2, Par3, ... * Insert procedure code. ENDPROC

-OR-

В	Copy Code
PROCEDURE myProcedure(Par1, Par2, Par3, ...) * Insert procedure code. ENDPROC

The first procedure includes an LPARAMETERS statement that can contain one or more parameters. The second procedure lists the same parameters enclosed by parentheses (()) immediately following the procedure name. Using the LPARAMETERS statement or enclosing the parameter list in parentheses defines the parameters with local scope for the procedure. You can also use the PARAMETERS keyword instead of LPARAMETERS to accept privately scoped parameters. You can pass multiple values to a procedure or function by separating the values with commas.

For example, the following examples show procedure definitions that include parameters. The first procedure includes an LPARAMETERS statement and two parameters, myPar1 and myPar2. The second procedure lists the same parameters enclosed by parentheses (()) immediately following the procedure name. Both procedures add the value in myPar2 to myPar1 and assign the result to myPar1. By default, data passes to procedures by reference, so the new value of myPar1 replaces its original value.

В	Copy Code
PROCEDURE myProcedure LPARAMETERS myPar1, myPar2 myPar1 = myPar1 + myPar2 ENDPROC

-OR-

В	Copy Code
PROCEDURE myProcedure(myPar1, myPar2) myPar1 = myPar1 + myPar2 ENDPROC

You can include parameters similarly in a function definition. For more information, see PROCEDURE Command, FUNCTION Command, LPARAMETERS Command, and PARAMETERS Command.

You can pass data, or specifically, "arguments", from your program to procedures and functions in different ways, depending on the following:

• Whether you want to pass data by reference or by value. For more information, see Passing Data to Parameters.
  
  
• How you call the procedure or function. For more information, see How to: Call Procedures and Functions.
  
  

For example, when you call a procedure with the DO command, you can pass data using the WITH clause and a parameter list. In the following example, the variables myVar and myVar2 contain the values 4 and 5. When you call the procedure myProcedure using the DO command, the parameter list in the WITH clause passes the variables to the procedure:

В	Copy Code
myVar = 4 myVar2 = 5 DO myProcedure WITH myVar, myVar2

By default, variables and arrays pass to procedures by reference. Therefore, changes made in the procedure to passed variables and arrays are passed back to the calling program. For example, suppose the procedure increments the value in myVar by the value in myVar2. The modified value of myVar becomes the new value of myVar when the procedure returns control to the calling program.

Alternatively, if you want to use the DO command but want to pass data by value, enclose each parameter with parentheses (()) as shown in the following example:

В	Copy Code
DO myProcedure WITH (myVar), (myVar2)

When you call a function, you can pass data using a parameter list enclosed in parentheses (()) as shown in the following line of code:

В	Copy Code
myFunction(myVar, myVar2)

By default, variables and arrays pass to user-defined functions by value. Therefore, changes made in the function to passed variables and arrays are not passed back to the calling program. However, you can pass variables and arrays by reference by prefacing variables and arrays with the at sign (@) as shown in the following line of code:

В	Copy Code
myFunction(@var1, @var2, ...)

The following table summarizes the ways you can pass variables to procedures and functions in the example.