FileToPage (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / Binding functions

Binding between a control and a WLanguage variable or between a control and a data file item
Binding to an item: types of link
Miscellaneous

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FileToPage (Function)

In french: FichierVersPage

Not available with this kind of connection

Automatically updates the controls of a page with:

the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).

Only the binding to the data file items is supported. Bindings to WLanguage variables are not supported in this version.

Remark: FileToPage does not read records on the data file. The value of the record loaded in memory is used to update the controls. Therefore, a record must be loaded in memory previously (with HRead, HReadSeek, HReadFirst, etc.).

Example

HReadSeekFirst(CUSTOMER, NAME, "PAUL")
IF HFound() = True THEN FileToPage()

// Read the record and transfer the items to the controls
HReadFirst(CUSTOMER, NAME)
FileToPage()

Syntax

FileToPage([<Page> [, <Source>]])

<Page>: Page name

Name of the page where the controls must be updated with the values of the current record in the data file. If this parameter is not specified or is an empty string (""), the page that contains the current code is used.
If this parameter is specified, it must correspond to the name of the current page. Otherwise, an error occurs.

<Source>: Optional character string

Name of the source the controls to be updated are bound to. This source can be:
The name of a data file: only the controls bound to the items of the data file are taken into account.
The name of a WLanguage variable: only the controls bound to the WLanguage variable are taken into account.
Remarks:
If the name of the variable is enclosed in quotes, the control will be bound to the specified variable.
If the name of the variable is not enclosed in quotes, the control will be bound to the variable data (e.g., a variable containing the name of another variable).
If this name is not specified, all the page controls bound to a data file item described in the data model editor or to a WLanguage variable will be taken into account.

Remarks

Binding between a control and a WLanguage variable or between a control and a data file item

The binding between a control and a WLanguage variable or between a control and a data file item can be determined:

In the editor, in the control description window ("Binding" tab).
Programmatically, with the DataBinding property.

Binding to an item: types of link

There are two types of bindings between a control and an item

direct binding: In this case, FileToPage transfers the value of the items from the record loaded in memory to the bound control, without reading any values.
binding by reading the records in the associated data file.

Miscellaneous

Space characters in HFSQL items are kept.
FileToPage updates the Image controls bound to image memo items.
FileToPage is not available on views. The values of the items must be assigned to each control.
Binding with "Secure Password" items:
- In an Edit control bound to a Password item, "*****" characters are displayed. If the Edit control is of type "Password", dots are displayed instead.
- The value of the "Password" item cannot be read again until the user changes the password value.
- The value of the "Password" item can still be compared to a string (e.g., "" or "1234").

Component: wd300page.dll