Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Automatic error handling
  • Passing parameters
  • Running a stored procedure from an SQL code
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
<Connection variable>.ExecuteProcedure (Function)
In french: <Variable Connexion>.ExécuteProcédure
HFSQL Client/ServerAvailable only with this kind of connection
Runs a stored procedure.
// Describe the connection
ConnectionHF is a Connection
// Run the "SalesPerYear" procedure and pass "2019" in parameter
HFConnection.ExecuteProcedure("SalesPerYear", 2006)
<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>.

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:
Component: wd280hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help