|
|
|
|
|
|
|
|
|
|
InitialItem (Property) In french: RubriqueOrigine
InitialItem is used to find out the initial name of an item found in a query. This name is known from the alias of this item. Remark: The InitialFile property is used to get the original name of the data file associated to an item in a query. This name is known from the alias of this item.
HExecuteSQLQuery("SampleQuery", "SELECT Customer.CustName AS MySuperCustomer FROM Customer")
Trace(SampleQuery.MySuperCustomer.InitialFile)
Trace(SampleQuery.MySuperCustomer.InitialItem)
Syntax
Result> = <Query>.<Item alias>.InitialItem
<Result>: Character string - Initial name of the item associated with the alias of the item,
- Empty string ("") if the alias of the item is an aggregate or if it corresponds to a counter.
<Query>: Character string Name of the query containing the item. This parameter can also correspond to the name of an HFSQL data file, to the name of an HFSQL view, etc. <Item alias>: Character string Name of the item in the result of the query (or in the data file, view, etc.).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|