HListStoredElement (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListStoredElement (Function)

In french: HListeElémentStocké

Available only with this kind of connection

Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).

Example

// Récupérer les éléments présents sur le serveur
ListeElément is string
ListeElément = HListStoredElement("MaConnexion", hLstDetail + hLstAll)

// Ajoute la liste des éléments dans COMBO_COMBO1
ListAdd(COMBO_COMBO1, ListeElément)

Syntax

<Result> = HListStoredElement(<Connection> [, <Options>])

<Result>: Character string

List of requested elements. The result is more or less detailed depending on the constant used.
hLstDetail is not specified <Name of element 1> + TAB + <Type> + CR + <Name of element 2> + CR +...
hLstDetail is specified <Name of element 1> + TAB + <Type> + TAB + <Author name> + TAB + <Date and time of update> + TAB + <Name of update author> + TAB + <Name of update computer> + TAB + <Size> + CR +...
Where:
<Nom Elément X> Logical name of procedure collection, procedure or query. The name of the procedure has the following format: <Name of set of procedures>.<Name of procedure>.
<Type> Element type: Value used to identify the item listed:
eltProcedure The listed element is a procedure.
eltQuery The listed element is a query.
eltSetOfProcedures The listed element is a set of procedures.
<Nom Auteur> Name of the person who created the element.
<Date Heure MAJ> Date and time of last item update.
<Nom Auteur MAJ> Name of the person who last updated the item.
<Nom Machine MAJ> Name of the machine that last updated the item.
<Taille>: Size of collection or query (0 for a procedure).

<Connection>: Character string or Connection variable

Connection to the HFSQL server. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Options>: Optional Integer constant (or combination of constants)

Type of list to perform:
hLstAll
(Default value) Lists all elements in the following order: procedure collections, stored procedures and queries.
hLstDetail Lists the detailed information.
hLstQuery Lists the queries.
hLstSet Lists the sets of procedures.
hLstStoredProcedure Lists the stored procedures.

Component: wd300hf.dll