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.
Versions 09 and later
DescribedName
New in version 09
DescribedName
DescribedName
The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).
Versions 11 and later
ExecutionCompleted
New in version 11
ExecutionCompleted
ExecutionCompleted
The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.
Versions 09 and later
FilterCondition
New in version 09
FilterCondition
FilterCondition
The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
Versions 09 and later
FilteredItem
New in version 09
FilteredItem
FilteredItem
The FilteredItem property is used to identify the item that has a filter implemented by HFilter.
Versions 09 and later
FilterWithBounds
New in version 09
FilterWithBounds
FilterWithBounds
The 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.
Versions 09 and later
MaxAutoID
New in version 09
MaxAutoID
MaxAutoID
The MaxAutoID property is used to get the maximum automatic identifier of a replicated data file.
Versions 09 and later
MaxValue
New in version 09
MaxValue
MaxValue
The 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.
Versions 09 and later
MinAutoID
New in version 09
MinAutoID
MinAutoID
The MinAutoID property is used to get the minimum automatic identifier of a replicated data file.
Versions 09 and later
MinValue
New in version 09
MinValue
MinValue
The 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.
Versions 09 and later
Name
New in version 09
Name
Name
The 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.
Versions 09 and later
NbItem
New in version 09
NbItem
NbItem
The 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.
Versions 09 and later
NbKeyItem
New in version 09
NbKeyItem
NbKeyItem
The 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.
Versions 09 and later
NbMemoItem
New in version 09
NbMemoItem
NbMemoItem
The 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.
Versions 09 and later
RecordSize
New in version 09
RecordSize
RecordSize
The 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.
Versions 12 and later
SQLCode
New in version 12
SQLCode
SQLCode
The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file).
Versions 09 and later
Type
New in version 09
Type
Type
The Type property is used to get:
  • the type of element described through programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of object.
  • the type of value stored in a variant.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment