InitialFile (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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.

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store Apps mode.

New in version 18

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

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

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.).