Note: This page includes content based on the F1 documentation for Centura development. It may be partially converted to support APF development, but should be regarded to be of uncertain actuality. It is provided as is. Eventually, it should be replaced by documentation available from within Visual Studio.
SalNumber DataSourceFormatSqlCount(SalString sCountBind, ref SalString lsStmt)
The DataSourceFormatSqlCount formats the select statement for a data source to count how many objects match the current where expressions.
| Name | Description |
|---|---|
| SalString sCountBind | Fully qualified bind variable to receive the count result. |
| ref SalString lsStmt | The complete select statement for a data source to count how many objects match the current where expressions. |
This method does not return a value.
The select statement follows the template "select count(*) from <views> where <default where> and <parent where> and <user where>".
<views> - the view(s) specified in Foundation1 properties.
<default where> - the where expression specified in Foundation1 properties
<parent where> - the where expression generated by the framework for detail data sources as a result of master-detail relationships between the data sources.
<user where> - extra where expression set by method DataSourceUserWhere (e.g. by using the query dialog).