|
|
|
|
|
|
|
|
- Automatic error handling
- Passing parameters
- Running a stored procedure from an SQL code
<Connection variable>.ExecuteProcedure (Function) In french: <Variable Connexion>.ExécuteProcédure
 Available only with this kind of connection
// Describe the connection
ConnectionHF is a Connection
// Run the "SalesPerYear" procedure and pass "2019" in parameter
HFConnection.ExecuteProcedure("SalesPerYear", 2006)
Syntax
<Result> = <Connection>.ExecuteProcedure(<Stored procedure> [, <Parameter 1> [... [, <Parameter N>]]])
<Result>: Type corresponding to the result - Result of the stored procedure: record, array of records, array of simple types, etc.
- Empty string ("") if <Stored procedure> does not return a result.
<Connection>: Connection variable Name of the Connection variable that describes the connection to the server that executes the stored procedure. <Stored procedure>: WLanguage procedure Name of the stored procedure to run. <Parameter 1>: Optional variant First parameter to pass to <Stored procedure>. <Parameter N>: Optional variant Nth parameter to pass to <Stored procedure>. Remarks Automatic error handling The automatic management of errors is disabled in the stored procedures. However, <Source>.OnError can be used to run a specific procedure (stored procedure). Passing parameters The parameters passed to the stored procedure are passed "by reference": if these parameters are modified in the stored procedure, they will also be modified in the application that ran this stored procedure. Running a stored procedure from an SQL code A stored procedure can be called:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|