ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Binding functions
  • Binding between a control and a WLanguage variable or between a control and a data file item
  • Section updates: Special cases
  • Updating data in the Table control (or in Looper controls)
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
PageToSource (Function)
In french: PageVersSource
ODBCNot available with this kind of connection
Automatically updates:
  • the value of the items in a data file with the value of the controls in the page. The data file items bound to the page controls are automatically updated with the values of these controls.
  • the value of the WLanguage variables with the value of the page controls. The WLanguage variables bound to the page controls are automatically updated with the values of these controls.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
Remarks:
  • The PageToSource function cannot be used to write to the data file: only variables in data file fields are assigned (i.e. variables in the Record loaded in memory).. To modify the records, use HAdd, HModify, HWrite, etc.
  • PHP Only the binging to the data file items is supported. Bindings to WLanguage variables are not supported in this version.
Example
// Clic sur BTN_AJOUTER
PageToSource()
HAdd(Client)
IF HErrorDuplicates() = True THEN
	Error("Ce numéro existe déjà")
END
Syntax
PageToSource([<Page> [, <Source>]])
<Page>: Page name
Name of the page that contains the controls.
If this parameter is not specified or is an empty string (""), the page that contains the current code is used.
PHP 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 containing the data to update. This source can be:
  • The name of a data file: only fields linked to this data file are taken into account.
  • The name of a WLanguage variable: only fields linked to this 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 window/page controls bound to a data file 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.

Section updates: Special cases

  • To automatically assign the NULL value to an item with PageToSource:
    1. Check "Support NULL values" in the data file description.
    2. Check "Allow NULL values" for the item in the data model editor.
    3. Check "Return NULL if empty" in the "Details" tab of the Edit control bound to the item.
  • The items of the data file that are not bound to a control are not updated by PageToSource.
  • If multiple controls in the window or page are bound to the same data file item, PageToSource may not update the bound item properly. It is not recommended to bind multiple controls of a window or page to the same item.
  • PageToSource does not update the items with the values from Image controls. Use the HLinkMemo function.
  • PageToSource is not available on views.
  • Link with "Secure password" fields : The value of the "Secure password" field is not modified until the user modifies the value in the field linked to the field.

Updating data in the Table control (or in Looper controls)

PageToSource has no effect on the content of a Table control.
The data is actually transferred from a Table control to the data source (data file or variable) when changes are saved. This backup is performed:
  • after input, if the "Save during row exit (Modif.)" option is selected ("Details" tab of the Table control description window),
  • with the TableSave function.
The same principle applies to the Looper controls bound to a data source.
Component: wd300page.dll
Minimum version required
  • Version 14
Comments
Click [Add] to post a comment

Last update: 09/11/2024

Send a report | Local help