<Connection variable>.ExecuteProcedure (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

HFSQL functions

HFSQL Client/Server functions

Prefix syntax

ExecuteProcedure

Presentation

Example

See also

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

AddScheduling

AddTask

AddUser

Backup

CancelBackup

CheckServerUpdate

ConnectionQuality

CopyFile

DeactivateServerTrigger

DeleteBackup

DeleteDatabase

DeleteDirectory

DeleteFile

DeleteGroup

DeleteLink

DeleteParameter

DeleteQuery

DeleteScheduledBackup

DeleteScheduledOptimization

DeleteScheduling

DeleteServerTrigger

DeleteSet

DeleteTask

DeleteUser

DescribeServerTrigger

DisconnectClient

DuplicateDatabase

EndNoDatabaseAccess

ExecuteProcedure

ExecuteScheduledBackup

ExecuteScheduling

InfoBackup

InfoDatabaseProperty

InfoDatabaseRights

InfoFileProperty

InfoFileRights

InfoGroup

InfoServer

InfoServerProperty

InfoServerRights

InfoTask

InfoUser

InfoView

InfoViewRights

ListDatabase

ListGroup

ListParameter

ListScheduledBackup

ListScheduledOptimization

ListScheduling

ListStoredElement

ListTask

ListUser

LoadParameter

ManageServerUpdate

ManageTask

ModifyDatabaseProperty

ModifyDatabaseRights

ModifyFileProperty

ModifyFileRights

ModifyGroup

ModifyScheduledBackup

ModifyScheduledOptimization

ModifyScheduling

ModifyServerProperty

ModifyServerRights

ModifyTask

ModifyUser

ModifyViewRights

NoDatabaseAccess

NotifAddCCRecipient

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

OperationInProgress

Priority

PriorityClient

RestoreBackup

RetrieveBackup

RetrieveLog

SaveParameter

SendMessageToClient

ServerMaintenance

SetServer

SimulateNetwork

StartServerUpdate

StopServer

UpdateQuery

UpdateSet

UpdateView

InfoLock

ChangePassword

InfoLock

Track

TrackStop

UpdateLink

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.

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

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 <Source>.ExecuteSQLQuery or SQLExec for example,
from an external application that is using the ODBC driver for HFSQL or the OLE DB provider for HFSQL.

For more details, see Stored procedures and queries (HFSQL Client/Server).

Component: wd280hf.dll