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.
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