|
|
|
|
|
|
|
|
|
|
- Automatic error handling
- Passing parameters
- Running a stored procedure from an SQL code
HExecuteProcedure (Function) In french: HExecuteProcedure
 Available only with this kind of connection
HExecuteProcedure("ConnexionHF", "VenteParAnnée", 2019)
Syntax
<Result> = HExecuteProcedure(<Connection> , <Stored procedure> [, <Parameter 1> [... [, <Parameter N>]]])
<Result>: Type corresponding to the result - Result of stored procedure: record, array of records, array of simple types, ...
- Empty string ("") if <Stored procedure> does not return a result.
<Connection>: Character string or Connection variable Connection to the server that runs the stored procedure. This connection corresponds to: <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, HOnError can be used to run a specific procedure (stored procedure). Passing parameters 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 executed the stored procedure. Running a stored procedure from an SQL code A stored procedure can be called:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|