PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
MySource (Reserved word)
In french: MaSource
MySource is used to handle the current data source (file, view or query) associated with a report or with a browsing table. When the project is run, this keyword is automatically replaced by the current data source.
Benefit: MySource is used to:
  • Make the code independent of the current data source.
  • Access the value of an item of the current record in the current data source.
  • Retrieve the name of the data source to perform a HFSQL process.
  • Indicate the window containing a table to print in a report on table.
Example
// Retrieve the name of the current data source
NameDataSource = MySource..Name

// Retrieve the name of the customer currently printed
IF MySource.CustName = "Montgomery" THEN
CALC_TotalBT..BrushColor = LightRed
END
// Modify the data source of a report on table in its opening code
PROCEDURE RPT_Customer_Table(sNameSourceTable)
MyReport..MySource = sNameSourceTable
Syntax
MySource
Remarks
  • MySource can only be used in the processes associated with:
    • a report,
    • a browsing table.
  • MySource cannot be used in the controls whose data source is a variable.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment