ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Binding functions
  • Binding between a control and a WLanguage variable or between a control and an item of a data file
  • Binding to an item: types of bindings
  • Miscellaneous
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Automatically initializes the controls of a window 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. 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).
PHP Only the binding to the items of a data file is supported. Bindings to WLanguage variables are not supported in this version.


Remarks:
  • WindowFromSource 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 PageFromSource.
Example
// Searches for customer in the data file
HReadSeekFirst(CUSTOMER, NAME, "PAUL")
IF HFound() = True THEN
	// Displays the client found in the current window
	WindowFromSource(CUSTOMER)
END
// Read the record and 
// transfer items to the controls in WIN_Customer
HReadFirst(CUSTOMER, NAME)
WindowFromSource(CUSTOMER, WIN_Customer)
Syntax
WindowFromSource(<Source> [, <Window>])
<Source>: Character string
Source to which the items to be updated are bound. For example, 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).
<Window>: Optional window name
Name of the window containing the controls to be updated.
Summary: Called when a control gains focus.
PHP If this parameter is specified, it must correspond to the name of the current page. Otherwise, an error occurs.
Remarks

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

The binding between a control and a WLanguage variable or between a control and an item of a data file can be determined:
  • In the editor, in the control description window ("Binding" tab).
  • Programmatically, with the DataBinding property.

Binding to an item: types of bindings

There are two types of bindings between a control and an item
  • direct binding: In this case, WindowFromSource 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: WindowFromSource must not be in the window "Global declarations" event. The function must be in the "Initialization" event of the window.
  • Space characters in HFSQL items are kept.
  • WindowFromSource updates Image controls with the value of the bound image memo items.
  • WindowFromSource 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.
  • WindowFromSource 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: wd290obj.dll
Minimum version required
  • Version 27
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/15/2024

Send a report | Local help