ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
<Connection variable>.ListStoredElement (Function)
In french: <Variable Connexion>.ListeElémentStocké
HFSQL Client/ServerAvailable only with this kind of connection
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
Example
// Describe the connection
MyConnection is Connection

// Retrieve the elements found on the server
ElementList is string
ElementList = MyConnection.ListStoredElement(hLstDetail + hLstAll)

// Adds the list of element into COMBO_COMBO1
COMBO_COMBO1.Add(ElementList)
Syntax
<Result> = <Connection>.ListStoredElement([<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:
    eltProcedureThe listed element is a procedure.
    eltQueryThe listed element is a query.
    eltSetOfProceduresThe 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>: Connection variable
Name of the Connection variable that describes the connection to the HFSQL server.
<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.
hLstDetailLists the detailed information.
hLstQueryLists the queries.
hLstSetLists the sets of procedures.
hLstStoredProcedureLists the stored procedures.
Component: wd300hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/05/2024

Send a report | Local help