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
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Automatically initializes:
  • the values of a data file's items in memory with the values from the controls in the window. The data file items bound to the window controls are automatically updated with the values of these controls.
  • the value of the WLanguage variables with the value of the window controls. The WLanguage variables bound to the window controls are automatically updated with the values of these controls.
Remarks:
  • The function SourceFromWindow FUNCTION function does not write to the data file: only the variables of the data file fields are assigned (i.e., the variables of the record loaded into memory). To modify the records, use HAdd, HModify, HWrite, etc.
Example
// Clic sur le bouton "Ajouter"
SourceFromWindow(Client)
HAdd(Client)
IF HErrorDuplicates() = True THEN Error("Ce numéro existe déjà")
Syntax
SourceFromWindow(<Source> [, <Window>])
<Source>: Type corresponding to the specified source
Name of the source containing the data to update. For example, this source can be:
  • The name of a data file. In this case, only the controls bound to the items of the data file are taken into account.
  • The name of a WLanguage variable. In this case, 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).
<Window>: Window name
Name of the window that contains the controls.
Summary: Called when a control gains focus.
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 SourceFromWindow:
    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 SourceFromWindow.
  • If multiple controls in the window or page are bound to the same data file item, SourceFromWindow may not update the bound item properly. It is not recommended to bind multiple controls of a window or page to the same item.
  • SourceFromWindow does not update the items with the values from Image controls. Use the HLinkMemo function.
  • SourceFromWindow 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.
Component: wd300obj.dll
Minimum version required
  • Version 27
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help