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
The Property DescribedName is used to manage the logical name of HFSQL files.
Versions 11 and later
ExecutionCompleted
New in version 11
ExecutionCompleted
ExecutionCompleted
The Property ExecutionTerminated allows you to know if a query or a HFSQL Classic or Client/Server view has finished executing.
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 FilteredTopic is used to find out the topic on which a filter has been set up 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
The IdAutoMax property allows to know 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 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
The Property Name allows you to know:
  • 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 NbRubric property gives the total number of headings (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
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 you to know the SQL code of a query created with the query editor (file extension ".WDR").
Versions 09 and later
Type
New in version 09
Type
Type
The Property Type allows to know:
  • 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