|
|
|
|
|
<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).
MyConnection is Connection
ElementList is string
ElementList = MyConnection.ListStoredElement(hLstDetail + hLstAll)
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:
| | eltProcedure | The listed element is a procedure. | eltQuery | The listed element is a query. | eltSetOfProcedures | The 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. | 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|