PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
Returns the list of elements stored on a HFSQL server (sets of procedures, stored procedures or queries).
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVJava This function is now available for the Java applications.
New in version 22
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
WINDEVJava This function is now available for the Java applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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> [, <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>: Character string (with or without quotes) or Connection variable
Connection to the HFSQL server. This connection corresponds to:
<Options>: Optional Integer constant (or combination of constants)
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 elements in the following order: sets of procedures, stored procedures and queries.
Component : wd250hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment