analyze_="view"

<do action_="sql" analyze_="view" sql_="[SQL]" value_="@r"/> populates @r with complete SQL metadata for the view, based on the SQL query [SQL].

Description

After analyze_="view" determines the SQL metadata, @r can then be used in <do action_=”sql” put_=”view” data_="{@r}"/>. analyze_="view" can analyze Macro Language queries as well as SQL. If you are analyzing a Macro Language query, use the xml_ attribute instead of sql_.

Syntax

<dynamic>
    <do action_="sql" analyze_="view"
     sql_="[SQL]" OR xml_="[XML]"
     names_="labels"|"names"
     value_="@r"/>
</dynamic>

Attributes for analyze_="view"

sql_
The SQL query to analyze.
xml_
Macro Language source code, which may be specified as text or as a list of XML values.
names_
Specifies whether to use MDB column names or column labels ("labels" is the default value).
vars_
An optional dictionary of the variables to be passed.
value_
The information returned by analyze_="view" is saved as a package to the dynamic variable @r. {@r} may then be used as the dict_= attribute of a put_="view" transaction.