PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Bounds for a report based on a data file
  • Limit for a report
  • Limits
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
..MaxValue is used to:
  • find out and modify the upper bound for a report based on a data file. The upper bound is the maximum value allowed for the search key of the HFSQL data file used as report source
  • find out the upper bound of the current filter (defined by HFilter) on a HFSQL data file, a view or a query.
  • find out the maximum value for a chart series.
  • find out and modify the maximum value for some types of controls.
Example
Reports and Queries
// Print the customers found between "DUPONT" and "DURANT"
RPT_MyFileReport..MinValue = "DUPONT"
RPT_MyFileReport..MaxValue = "DURANT"
Syntax

Finding out the upper bound defined for a control or report Hide the details

<Current Value> = <Element Name>..MaxValue
<Current Value>: Character string
Current value of upper bound:
  • for the report based on a data file.
  • for a control found in a window or page.
<Element Name>: Character string (with or without quotes)
This parameter corresponds to:
  • the name of report used (report based on a data file).
  • the name of control whose upper bound is requested (control in a window or in a page). The list of controls concerned is located in the "Limitations" paragraph.

Modifying the upper bound of a control or report Hide the details

<Element Name>..MaxValue = <New value>
<Element Name>: Character string (with or without quotes)
This parameter corresponds to:
  • the name of report used (report based on a data file).
  • the name of control whose upper bound must be modified (control in a window or in a page).
<New value>: Integer
New value of the upper bound:
  • for the report based on a data file.
  • for a window control. The list of controls concerned is located in the "Limitations" paragraph.
Reports and Queries

Finding out the upper bound defined for the current filter Hide the details

<Current Value> = <Element Name>..MaxValue
<Current Value>: : Type corresponding to the filter used
  • Current value of upper bound for the filter currently used on the specified element. This filter was defined by HFilter.
  • Empty string ("") in the following cases:
    • no filter was defined for the specified element.
    • the filter is disabled.
    • no bound was specified for the filter.
<Element Name>: : Character string (with or without quotes)
Name of data file, query or view used.
Reports and Queries

Finding out the maximum value of a chart series Hide the details

<Maximum Value> = <Series>..MaxValue
<Maximum Value>: Integer
Maximum value of the series. This value exists only if it was calculated (if the series was drawn for example).
<Series>: Character string
Series to use. Use the following notation: <Chart Name>[<Series Number>].
Remarks
Reports and Queries

Bounds for a report based on a data file

The bounds are used to select the records whose search key is included between the value of the lower bound (returned by ..MinValue) and the value of the upper bound (returned by ..MaxValue).
Reports and Queries

Limit for a report

..MaxValue only applies to the reports based on HFSQL data files. When creating the report, you must specify that the browse is bounded by the maximum value.

Limits

Minimum version required
  • Version 9
This page is also available for…
Comments
Video MaxValue
https://youtu.be/FR7TPS9TGtQ

https://windevdesenvolvimento.blogspot.com/2019/01/dicas-1990-windev-comandos-31.html
amarildo
23 Jan. 2019