PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • 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
<Connection variable>.ExecuteProcedure (Function)
In french: <Variable Connexion>.ExécuteProcédure
HFSQL Client/ServerAvailable only with this kind of connection
Runs a stored procedure.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
Example
// 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>: Variant
  • Result of the stored procedure.
  • 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 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:
See Stored procedures and queries (HFSQL Client/Server) for more details.
Component : wd250hf.dll
See also
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment