Sets the data source description as an SQL clause.
Data Source could be a very complex multilevel join of several tables or views. This method sets the SQL clause which fully describes the data source's set of tables.
When this method is called, the data source setup configured in the UI is abandoned.
Note: The word "FROM" in the method's name refers to the SQL keyword "FROM".
Syntax
Function SetFROM( sql )
Parameters
string sql - the SQL clause which describes a complex data source.
Return Values
none
Example
DS.SetFrom "(dbo.Accounts a WITH (NOLOCK) LEFT JOIN dbo.Accounts p WITH (NOLOCK) ON a.ParentID=p.AccountID)" & _ "LEFT JOIN dbo.Users mu WITH (NOLOCK) ON a.ManagerID=mu.UserID)"
