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/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
The Property ConditionFiltre allows you to know the selection condition set up by the HFilter function on a data file, a HFSQL view or a query..
Versions 09 and later
FilteredItem
New in version 09
FilteredItem
FilteredItem
The Property Item Filtered makes it possible to know the Item on which a filter has been set by the HFilter function..
Versions 09 and later
FilterWithBounds
New in version 09
FilterWithBounds
FilterWithBounds
The Property FilterWithTerminals allows to know if terminals have been specified on the filter set up by the HFilter function on a data file, a HFSQL view or a 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
The IdAutoMin property allows to know the minimum automatic identifier on a replicated HEX@.
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,
  • an HFSQL view,
  • a query.
Versions 09 and later
NbKeyItem
New in version 09
NbKeyItem
NbKeyItem
The KeyNumber property gives the total number of key fields (including compound keys) present in an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
Versions 09 and later
NbMemoItem
New in version 09
NbMemoItem
NbMemoItem
The NbRubriqueMémo property gives the total number of memo headings present in an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
Versions 09 and later
RecordSize
New in version 09
RecordSize
RecordSize
The RecordSize property allows to obtain the Length( in bytes) of an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
Versions 12 and later
SQLCode
New in version 12
SQLCode
SQLCode
The Property CodeSQL allows to know the SQL code of a query created with the query editor (HEX@ with ".WDR" extension).
Versions 09 and later
Type
New in version 09
Type
Type
Type is used to find out:
  • the type of 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 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