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
  • Linking to an item: types of links
  • Miscellaneous
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Automatically updates the controls in a window or page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
Remarks:
  • <Window>.FromSource 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:
  • WEBDEV - Server codePHP This function is also available for WEBDEV pages. It is equivalent to <Page>.FromSource.
  • PHP Only the binding to the data file items is supported. Bindings to WLanguage variables are not supported in this version.
Example
// Searches for customer in the data file
CUSTOMER.ReadSeekFirst(NAME, "PAUL")
IF CUSTOMER.Found() = True THEN
	// Displays the client found in the current window
	WIN_Customer.FromSource()
END

// Read the record and
// transfer items to the controls in WIN_Customer
CUSTOMER.ReadFirst(NAME)
WIN_Customer.FromSource()
Syntax
<Window>.FromSource([<Source>])
<Window>: Window name
Name of the window or page containing the controls to be updated.
Summary: Called when a control gains focus.
<Source>: Optional character string
Name (in quotation marks) of the source the controls to be updated are bound to. This source can be:
  • The name of a data file: only fields linked to a field in this 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).
If this name is not specified, all the window 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.

Linking to an item: types of links

There are two types of bindings between a control and an item
  • direct binding: In this case, <Window>.FromSource 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

  • Auto-filled Combo Box control bound to an HFSQL data file: <Window>.FromSource must not be in the "Global declarations" event of the window. The function must be in the "Initialization" event of the window.
  • Space characters in HFSQL items are kept.
  • <Window>.FromSource updates Image controls with the value of the bound image memo items.
  • <Window>.FromSource supports the NULL value. If the item content is NULL, an empty string will be displayed in the bound Edit control. To change this display mode, use ControlError.
  • <Window>.FromSource 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: wd300obj.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/07/2024

Send a report | Local help