PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
InitialFile (Property)
In french: FichierOrigine
The Property FileOrigin is used to find out the original name of the data file associated of a field in a query. This name is known from the alias of this item.
Remark: 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: From version 19, HFSQL is the new name of HyperFileSQL.
Example
RequêteExemple is Data Source
HExecuteSQLQuery("RequêteExemple", "SELECT Client.NomCli AS MonSuperClient FROM Client")
Trace(RequêteExemple.MonSuperClient.FichierOrigine) // Client
Trace(RequêteExemple.MonSuperClient.RubriqueOrigine) // NomCli
Syntax
<Result> = <Query>.<Item alias>.InitialFile
<Result>: Character string
  • Name of the data file associated with the item,
  • Empty string ("") if the item is an aggregate or if it corresponds to a counter.
<Query>: Character string (with or without quotes)
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 (with or without quotes)
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