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
..MinValue is used to:
  • find out and modify the lower bound for a report based on a data file. The lower bound corresponds to the minimum value allowed for the search key of the HFSQL data file used as report source.
  • find out the lower bound of the current filter (defined by HFilter) on a HFSQL data file, a view or a query.
  • find out the minimum value of a chart series.
  • find out and modify the minimum 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 lower bound of a control or report Hide the details

<Current value> = <Element name>..MinValue
<Current value>: Character string
Current value of lower 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 lower bound is requested (control in a window or in a page). The list of controls concerned is located in the "Limitations" paragraph.

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

<Element name>..MinValue = <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 lower bound must be modified (control in a window or in a page).
<New value>: Integer
New value of lower bound:
  • for the report based on a data file.
  • for a control found in a window or page. The list of controls concerned is located in the "Limitations" paragraph.
  • Versions 17 and later
    for the Rating control. Only the values 0 or 1 are allowed.
    New in version 17
    for the Rating control. Only the values 0 or 1 are allowed.
    for the Rating control. Only the values 0 or 1 are allowed.
Reports and QueriesHFSQL

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

<Current value> = <Element name>..MinValue
<Current value>: Type corresponding to the filter used
  • Current value of lower 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 minimum value of a chart series Hide the details

<Minimum Value> = <Serial>..MinValue
<Minimum Value>: Integer
Minimum value of series. This value exists only if it was calculated (if the series was drawn for example).
<Serial>: 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 lower bound (returned by ..MinValue) and the value of upper bound (returned by ..MaxValue).
Reports and Queries

Limit for a report

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

Limits

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


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