PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Automatic management of errors
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HExecuteProcedure (Function)
In french: HExecuteProcedure
HFSQL Client/ServerAvailable only with this kind of connection
Runs a stored procedure.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Run the "SalesPerYear" procedure and pass "2019" in parameter
HExecuteProcedure("HFConnection", "SalesPerYear", 2019)
Syntax
<Result> = HExecuteProcedure(<Connection> , <Stored procedure> [, <Parameter 1> [... [, <Parameter N>]]])
<Result>: Variant
  • Result of the stored procedure.
  • Empty string ("") if <Stored procedure> does not return a result.
<Connection>: Character string (with or without quotes) 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 management of errors

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