FileLink (Property)

and an item found in a data file.
and a variable.
Versions 15 and later
and several variables (in this case, each variable can be linked to a different property of the control).
New in version 15
and several variables (in this case, each variable can be linked to a different property of the control).
and several variables (in this case, each variable can be linked to a different property of the control).

Reminder: In most cases, the link between a control and an item or variable is defined in the window editor or in the page editor during the control description ("Link" tab). This link allows you to specify the file item that will be used by the synchronization functions (ScreenToFile, ScreenToSource, PageToFile, PageToSource, FileToScreen, FileToPage, SourceToScreen, SourceToPage).

Example of multi-file link:

This property is equivalent to ControlAlias.

Versions 15 and later

This property is now available for the Android applications.

New in version 15

This property is now available for the Android applications.

Versions 17 and later

This property is now available for the iPhone/iPad applications.

New in version 17

This property is now available for the iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store Apps mode.

This property is now available in Android Widget mode.

New in version 18

This property is now available in Windows Store Apps mode.

This property is now available in Android Widget mode.

This property is now available in Windows Store Apps mode.

This property is now available in Android Widget mode.

Versions 20 and later

This property is now available for the Table controls and for the table columns in the Android applications and in the iPhone/iPad applications.

New in version 20

This property is now available for the Table controls and for the table columns in the Android applications and in the iPhone/iPad applications.

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

// Links the EDT_Edit1 control with the Name item of the Customer data file
EDT_Edit1..FileLink = "Customer.Name"
// Same but from the Orders data file with 1 link
EDT_Edit2..FileLink = "Orders.CustomerID" + TAB + "Customer.CustomerID:Name"
// Same but from the OrdLine data file with 2 links
EDT_Edit3..FileLink = "OrdLine.OrdID" + TAB + ...
"Orders.OrdID:CustomerID" + TAB + "Customer.CustomerID:Name"
// Links TABLE_Table1 with Array_Month
TABLE_Table1..FileLink = ":Array_Month"
// Update on the screen
FileToScreen()

// Whenever SourceToScreen is called, the EDT_Current_Allowed control will have:
// - its displayed value updated by the Authorizing property of a class instance,
// - a background color assigned by the value of a global variable
gclContact is cContact
gsColor is int = PastelBlue
EDT_Current_Allowed..FileLink = ":gclContact.Authorizing" + TAB + ...
"value" + CR + ":gsColor" + TAB + "BackgroundColor"
// Update on the screen
SourceToScreen()

Syntax

Finding out the link between a control and an item or variable Hide the details

<Current link> = <Control name>..FileLink

<Current link>: Character string

Different types of links can be found:
No link: empty string ("")
Simple link with an item of a data file:

"<Base file>.<Base item>"

Complex link with an item of a data file:

"<Base file>.<Base item>[ + TAB + <Link> [+ TAB + <Link>]]"

where <Link> corresponds to:
<Linked file>.<Key>:<Linked item>[<Subscript>]
Link with a variable:

":<prefix><Variable name>"

or

":<Variable name>"

(the prefix is found only if the programming charter is enabled in the project).(the prefix is applied only if the code style is enabled in the project).
Not available.

<Control name>: Character string (with or without quotes)

Name of control whose file link is requested.

Modifying the link between a control and an item or variable Hide the details

<Control name>..FileLink = <New link>

<Control name>: Character string (with or without quotes)

Name of control whose file link will be modified.

<New link>: Character string

Different types of links can be defined:
No link: empty string ("")
Simple link with an item of a data file:

"<Base file>.<Base item>"

Complex link with an item of a data file:

"<Base file>.<Base item>[ + TAB + <Link> [+ TAB + <Link>]]"

where <Link> corresponds to:
<Linked file>.<Key>:<Linked item>[<Subscript>]
Note: the following syntax is also accepted:

<[Base file>.<Item>[<[Subscript]>] [: <Link> [: <Link>] ]

where <Link> = <Linked file>.<Key>:<DispItem> [<[Subscript]>]
Link with a variable:

":<prefix><Variable name>"

or

":<Variable name>"

The prefix must be specified only if the programming charter is enabled in the project (no matter whether prefixes are displayed or not).The prefix must be specified only if the code style is enabled in the project (no matter whether prefixes are displayed or not).
Not available.
Versions 15 and later
Link several properties with several variables: the character string describing the link must have the following format:

":" + <Name of variable 1> + TAB + <Name of property 1> + CR + ...
":" + <Name of variable 2> + TAB + <Name of property 2> + CR + ...
":" + <Name of variable N> + TAB + <Name of property N>

New in version 15
Link several properties with several variables: the character string describing the link must have the following format:

":" + <Name of variable 1> + TAB + <Name of property 1> + CR + ...
":" + <Name of variable 2> + TAB + <Name of property 2> + CR + ...
":" + <Name of variable N> + TAB + <Name of property N>

Link several properties with several variables: the character string describing the link must have the following format:

":" + <Name of variable 1> + TAB + <Name of property 1> + CR + ...
":" + <Name of variable 2> + TAB + <Name of property 2> + CR + ...
":" + <Name of variable N> + TAB + <Name of property N>

Remarks

ListView control

..FileLink is used to know and modify the link between the captions of a ListView control and an item of a data file.

Display error

ControlError is used to customize the error message displayed in the controls when the control value cannot be displayed.

Limits

..FileLink only applies to the controls found in a window or in a page.

..FileLink can only be used to create a link with a data file. You cannot create a link with a variable.

Versions 22 and later

..FileLink can now be used to create a link with a variable.

New in version 22

..FileLink can now be used to create a link with a variable.

This property only applies to the following controls:

Button control.
Static control.
Image control.