PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
These properties can be used on the HFSQL queries or views.
MaxValueThe MaxValue property is used to:
  • find out and modify the upper bound of a report based on a data file.
  • find out the upper bound defined for the current filter.
  • find out the maximum value of a chart series.
  • find out and modify the maximum value for some types of controls.
MinValueThe MinValue property is used to:
  • find out and modify the lower bound of a report based on a data file.
  • find out the lower bound defined for the current filter.
  • find out the minimum value of a chart series.
  • find out and modify the minimum value for some types of controls.
SQLCodeThe SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file).
FilterConditionThe FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
ExecutionCompletedThe ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.
FilterWithBoundsThe FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
MaxAutoIDThe MaxAutoID property is used to get the maximum automatic identifier of a replicated data file.
MinAutoIDThe MinAutoID property is used to get the minimum automatic identifier of a replicated data file.
NbItemThe NbItem property is used to get the total number of items (including composite keys) in a record of:
  • a file described in the data model editor,
  • a file described through programming,
  • an HFSQL view,
  • a query.
NbKeyItemThe NbKeyItem property is used to get the total number of key items (including composite keys) in a record of:
  • a file described in the data model editor,
  • a file described through programming,
  • an HFSQL view,
  • a query.
NbMemoItemThe NbMemoItem property is used to get the total number of memo items in a record of:
  • a file described in the data model editor,
  • a file described through programming,
  • an HFSQL view,
  • a query.
NameThe Name property is used to get:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
DescribedNameThe DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).
FilteredItemThe FilteredItem property is used to identify the item that has a filter implemented by HFilter.
RecordSizeThe RecordSize property is used to get the size (in bytes) of a record in:
  • a file described in the data model editor,
  • a file described through programming,
  • an HFSQL view,
  • a query.
TypeThe Type property is used to get:
  • the type of element (data file or item) defined programmatically or in the data model editor, view or query.
  • the type of object.
  • the type of data held in a Variant.
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment