PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

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
These properties can be used on the HFSQL queries or views.
Versions 09 and later
DescribedName
New in version 09
DescribedName
DescribedName
..DescribedName is used to manage the logical name of HFSQL files
Versions 11 and later
ExecutionCompleted
New in version 11
ExecutionCompleted
ExecutionCompleted
..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed
Versions 09 and later
FilterCondition
New in version 09
FilterCondition
FilterCondition
..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query
Versions 09 and later
FilteredItem
New in version 09
FilteredItem
FilteredItem
..FilteredItem is used to find out the item on which a filter was implemented by HFilter
Versions 09 and later
FilterWithBounds
New in version 09
FilterWithBounds
FilterWithBounds
..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query.
Versions 09 and later
MaxAutoID
New in version 09
MaxAutoID
MaxAutoID
..MaxAutoID is used to find out the maximum automatic identifier on a replicated file.
Versions 09 and later
MaxValue
New in version 09
MaxValue
MaxValue
..MaxValue 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
Versions 09 and later
MinAutoID
New in version 09
MinAutoID
MinAutoID
..MinAutoID is used to find out the minimum automatic identifier on a replicated file
Versions 09 and later
MinValue
New in version 09
MinValue
MinValue
..MinValue 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
Versions 09 and later
Name
New in version 09
Name
Name
..Name is used to find out:
  • 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
Versions 09 and later
NbItem
New in version 09
NbItem
NbItem
..NbItem is used to find out the total number of items (including composite keys) in a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 09 and later
NbKeyItem
New in version 09
NbKeyItem
NbKeyItem
..NbKeyItem returns the total number of key items (including composite keys) found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 09 and later
NbMemoItem
New in version 09
NbMemoItem
NbMemoItem
..NbMemoItem returns the total number of memo items found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 09 and later
RecordSize
New in version 09
RecordSize
RecordSize
..RecordSize is used to find out and modify the size (in bytes) of a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 12 and later
SQLCode
New in version 12
SQLCode
SQLCode
..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file)
Versions 09 and later
Type
New in version 09
Type
Type
..Type is used to find out:
  • the type of an element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of an object.
  • the type of the value stored in a variant
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment