|
|
|
|
|
|
|
|
<Connection variable>.ListStoredElement (Function) In french: <Variable Connexion>.ListeElé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). // 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:- <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:
| | | eltProcedure | The listed element is a procedure. | | eltQuery | The listed element is a query. | | eltSetOfProcedures | The listed element is a set of procedures. |
- <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>: 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: sets of procedures, stored procedures and queries. | | hLstDetail | Lists the detailed information. | | hLstQuery | Lists the queries. | | hLstSet | Lists the sets of procedures. | | hLstStoredProcedure | Lists the stored procedures. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|