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
..ViewName is used to:
  • find out the name of the HFSQL view, data source of a report
  • modify the name of the HFSQL view, data source of a report.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Find out the name of the data source for "RPT_CustomerReport"
ResViewName = RPT_CustomerReport..ViewName
Syntax

Finding out the name of the HFSQL view associated with a report Hide the details

<Result> = <Report name>..ViewName
<Result>: Character string
Name of the HFSQL view, data source of the specified report.
<Report name>: Character string (with or without quotes)
Name of report to use. A WLanguage error occurs if this parameter does not correspond to report associated with an HFSQL view.

Modifying the name of the HFSQL view associated with a report Hide the details

<Report name>..ViewName = <Name of HFSQL view>
<Report name>: Character string (with or without quotes)
Name of report to use. A WLanguage error occurs if this parameter does not correspond to report associated with an HFSQL view.
<Name of HFSQL view>: Character string
Name of the HFSQL view that must be used as data source for the specified report.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment