PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
..InitialFile is used to find out the initial name of the data file associated with an item found in a query. This name is known from the alias of this item.
Note: ..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
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 name>.<Name of 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 name>: Character string (with or without quotes)
Name of the query containing the item. This parameter can also correspond to the name of a HFSQL data file, to the name of a HFSQL view, ...
<Name of 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