PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
InitialFile (Property)
In french: FichierOrigine
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.
Remark: The InitialItem property is used to get the original name of an item in a query. This name is known from the alias of this item.
Versions 17 and later
iPhone/iPad This property is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for iPhone/iPad applications.
iPhone/iPad This property is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App This property is now available in Windows Store apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
SampleQuery is Data Source
HExecuteSQLQuery("SampleQuery", "SELECT Customer.CustName AS MySuperCustomer FROM Customer")
Trace(SampleQuery.MySuperCustomer.InitialFile) // Customer
Trace(SampleQuery.MySuperCustomer.InitialItem) // CustName
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
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