SetFROM

Description

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)" & _