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 DataSourceFormatSqlSelect(ref SalString lsStmt)
The DataSourceFormatSqlSelect formats the complete select statement for a data source.
Name | Description |
---|---|
ref SalString lsStmt | The complete select statement required to populate the data source according to current where and order by expressions. |
This method does not return a value
The select statement follows the template "select <columns> into <bind
variables> from <views> where <default where> and <parent where> and <user
where> order by <default or user order by>".
<columns> - the framework will collect a list of columns for all data items
attached to a data source. Applications can override the
DataSourceFormatSqlColumnUser method to add extra columns to the select
statement.
<bind variables> - the framework will collect a list of bind variables for all
data items attached to a data source. Applications can override the
DataSourceFormatSqlIntoUser method to add extra bind variables to the select
statement.
<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).
<default or user order by> - If an order by expression has been set by method DataSourceUserOrderBy (e.g. by using the query dialog), that order by statement
is used. Otherwise the order by statement set in Foundation1 properties is used.