<Connection variable>.ExecuteProcedure (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HFSQL Client/Server functions

ExecuteProcedure

Presentation

Example

Automatic management of errors

Passing parameters

Running a stored procedure from an SQL code

See also

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!

Automatic management of errors
Passing parameters
Running a stored procedure from an SQL code

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.ExecuteProcedure (Function)

In french: <Variable Connexion>.ExécuteProcédure

Available only with this kind of connection

Runs a stored procedure.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

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

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

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, <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:

from SQL code, with <Fichier HFSQL>.ExécuteRequêteSQL or SQLExec for example,
from an external application that is using the ODBC driver for HFSQL or the OLE DB provider for HFSQL.

See Stored procedures and queries (HFSQL Client/Server) for more details.

Component : wd250hf.dll