ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
InitialItem (Property)
In french: RubriqueOrigine
The property RubriqueOrigine property lets you know the original name of a field in a query. This name is known from the alias of this item.
Remarque: The InitialFile property is used to identify the original name of the data file associated with a field in a query.. This name is known from the alias of this item.
Example
HExecuteSQLQuery("RequêteExemple", "SELECT Client.NomCli AS MonSuperClient FROM Client")
Trace(RequêteExemple.MonSuperClient.FichierOrigine) // Client
Trace(RequêteExemple.MonSuperClient.RubriqueOrigine) // NomCli
Syntax
<Résultat> = <Requête>.<Alias de la rubrique>.RubriqueOrigine
<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.).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/13/2025

Send a report | Local help