Description

Gets the complete SQL expression stored in the scope object. You may request either the compiled or the original representation of the SQL expression. The compiled version has all custom fields expanded to their definitions and the syntax translated into that of the dialect of the database being used. You may pass a table alias as a parameter, in which case the compiled version will be returned and all the fields in the SQL statement will be pre-pended with that alias.

Syntax

Function Get(how)

Parameters

how (input) - determines how to retrieve the file

Return value

the scope file

Example

Code sample

DatabaseName.Scope.Get()

See also

Platform Objects and Methods

DB.sort

DB.AppendFinish