HExecuteProcedure (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

Automatic management of errors

Passing parameters

Running a stored procedure from an SQL code

HAddScheduledOptimization

HCS.FrameSize (Variable)

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HExecuteProcedure (Function)

In french: HExecuteProcedure

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 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 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 Java applications.

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:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a Connection variable.

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

from SQL code, with HExecuteSQLQuery 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: wd260hf.dll