PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HListStoredElement (Function)
In French: HListeElémentStocké
HFSQL Client/ServerAvailable only with this kind of connection
Returns the list of elements stored on a HFSQL server (sets of procedures, stored procedures or queries).
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
// Retrieve the elements found on the server
ElementList is string
ElementList = HListStoredElement("MyConnection", hLstDetail + hLstAll)

// Adds the list of element into COMBO_COMBO1
ListAdd(COMBO_COMBO1, ElementList)
Syntax
<Result> = HListStoredElement(<Connection Name> [, <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:
  • <Name of Element X>: Logical name of the set of procedures, the procedure or the query. The name of the procedure has the following format: <Name of Set of Procedures>.<Name of Procedure>.
  • <Type>: Type of element: Value used to identify the listed element:
    eltSetOfProceduresThe listed element is a set of procedures.
    eltProcedureThe listed element is a procedure.
    eltQueryThe listed element is a query.
  • <Author Name>: Name of the person who created the element.
  • <Date and Time of Update>: Date and time of the last update performed on the element.
  • <Name of Update Author>: Name of the person who performed the last update on the element.
  • <Name of Update Computer>: Name of the computer that performed the last update on the element.
  • <Size>: Size of the set or size of the query (0 for a procedure).
<Connection Name>: Character string (with or without quotes)
Name of the connection to the HFSQL server.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstSetLists the sets of procedures.
hLstDetailLists the detailed information.
hLstStoredProcedureLists the stored procedures.
hLstQueryLists the queries.
hLstAll
(Default value)
Lists all the elements in the following order: sets of procedures, stored procedures and queries.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment