ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

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

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

Last update: 05/26/2022

Send a report | Local help