DataSourceFormatSqlIntoUser

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.

SalString DataSourceFormatSqlIntoUser(  )

Applications should override the DataSourceFormatSqlIntoUser method to specify extra bind variables to be included in the select statement for the data source.

Returns

The return value should a list of comma-separated bind variables, with no comma sign after the last column.

Comments

The bind variables specified returned here must match the columns returned by method DataSourceFormatSqlColumnUser.

The DataSourceFormatSqlIntoUser is intended to be used when applications need information from the data source, that doesn't need to be presented to the user. Using DataSourceFormatSqlColumnUser and DataSourceFormatSqlIntoUser, the application can retrieve this information into window variables instead of data items, hence reducing the number of objects in the window, speeding up window creation times, and reducing the size of the application.

Example

Function: DataSourceFormatSqlIntoUser
Actions
   Return ":i_hWndFrame.frmEmployee.sId,
         :i_hWndFrame.frmEmployee.sName"

public SalString DataSourceFormatSqlIntoUser()
{
	using (new SalContext(this))
	{
		return frmEmployee.FromHandle(i_hWndFrame).sName.Text;
	}
}