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 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:
  • SourceToScreen 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 SourceToPage.
  • PHP Only the binding to the items of a data file is supported. Bindings to WLanguage variables are not supported in this version.
Example
// Searches for customer in the data file
HReadSeekFirst(CUSTOMER, NAME, "PAUL")
IF HFound() = True THEN
// Displays the client found in the current window
SourceToScreen()
END
 
// Read the record and
// transfer items to the controls in WIN_Customer
HReadFirst(CUSTOMER, NAME)
SourceToScreen(WIN_Customer)
Syntax
SourceToScreen([<Window> [, <Source>]])
<Window>: Window name
Name of the window or page 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.
<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 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 window controls bound to an item of 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 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, SourceToScreen 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: SourceToScreen 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.
  • SourceToScreen updates Image controls with the value of the bound image memo items.
  • SourceToScreen 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.
  • SourceToScreen 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 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help