Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development
<do action_="sql">
<do action_="sql"> provides a programmatic API to the SQL metadata store. (Available as of version 17.29)
reload_="catalog"
<do action_="sql" reload_="catalog"/> refreshes the entire database catalog in the caller's session.

Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
- Data Transformation
  Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
- Blocks
  Blocks allow users to reuse sections of Macro Language code and to parameterize values in that code for greater flexibility and power.
- Application Development
  - <dynamic>
    The <dynamic> element creates an environment in 1010data that maintains the state of system interactions and controls the running of queries.
  - <render>
    The <render> element provides the ability to configure certain QuickApp widgets when rendered to available output targets. A single <render> element contains one or more elements that specify output targets and settings for the final output.
  - <layout>
    The <layout> element is a nestable pseudo-operation that can be used to organize <widget> elements and other <layout> elements.
  - <widget>
    <widget> is used to define all visual components of a QuickApp, including drop-downs, text boxes, tables, and calendars. The form a widget takes is controlled by the class_ attribute.
  - <do>
    A <do> clause within a <dynamic> provides the ability for <dynamic> variables to be updated when some variable within the scope of the <dynamic> is changed.
  - <do action_="sql">
    <do action_="sql"> provides a programmatic API to the SQL metadata store. (Available as of version 17.29)
    - add_="column"
      <do action_="sql" add_="column" schema_="[SCHEMA]" table_="[TABLE]" objname_="[COLUMN]"/> creates a new dummy column in the specified table.
    - add_="schema"
      <do action_="sql" add_="schema" objname_="[SCHEMA]" desc_="[DESCRIPTION]" users_="[USERS]" admins_="[ADMINS]"/> creates a new empty schema with the name [SCHEMA].
    - add_="table"
      <do action_="sql" add_="table" schema_="[SCHEMA]" objname_="[TABLE]"/> adds an empty table to a specified schema.
    - add_="tvf"
      <do action_="sql" add_="tvf"> adds a new table-valued function to a specified schema.
    - add_="view"
      <do action_="sql" add_="view" schema_="[SCHEMA]" objname_="[TABLE]"/> adds an empty table to a specified schema.
    - analyze_="column"
      <do action_="sql" analyze_="column" path_="[PATH]" col_="[COLNAME]" value_="@r"/> analyzes the 1010data table at [PATH] and populates @r with complete SQL metadata for the single column.
    - analyze_="table"
      <do action_="sql" analyze_="table" path_="[PATH]" value_="@r"/> analyzes the 1010data table at [PATH] and populates @r with complete SQL metadata for the table.
    - 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].
    - check_="parse"
      <do action_="sql" check_="parse" sql_="[SQL]" value_="@r"/> attempts to parse the SQL statement.
    - del_="column"
      <do action_="sql" del_="column" schema_="[SCHEMA]" table_="[TABLE]" objname_="[COLUMN]"/> deletes a column from the specified table.
    - del_="schema"
      <do action_="sql" del_="schema" objname_="[SCHEMA]"/> deletes a schema from the catalog.
    - del_="table"
      <do action_="sql" del_="table" schema_="[SCHEMA]" objname_="[TABLE]"/> deletes a table from the specified schema.
    - del_="tvf"
      <do action_="sql" del_="tvf"> deletes a table-valued function with a given signature from the schema.
    - del_="view"
      <do action_="sql" del_="view" schema_="[SCHEMA]" objname_="[TABLE]"/> deletes a view from the specified schema.
    - get_="catalog"
      <do action_="sql" get_="catalog" catalog_="[CATALOG]" value_="@r"/> populates @r with a specified database catalog.
    - get_="column"
      <do action_="sql" get_="column" schema_="[SCHEMA]" table_="[TABLE]" objname_="[COLUMN]" value_="@r"/> populates @r with metadata for the specified column from the specified table in the specified schema.
    - get_="schema"
      <do action_="sql" get_="schema" objname_="[SCHEMA]" value_="@r"/> populates @r with a specified schema.
    - get_="table"
      <do action_="sql" get_="table" schema_="[SCHEMA]" objname_="[TABLE]" value_="@r"/> populates @r with metadata for the specified table from the specified schema.
    - get_="tvf"
      <do action_="sql" get_="tvf" schema_="[SCHEMA]" objname_="[FUNCTION]" signature_="[SIGNATURE]" value_="@r"/> populates @r with metadata for the specified table-valued function from the specified schema and signature.
    - get_="view"
      <do action_="sql" get_="view" schema_="[SCHEMA]" objname_="[TABLE]" value_="@r"/> populates @r with metadata for the specified view from the specified schema.
    - info_="privileges"
      <do action_="sql" info_="privileges" value_="@r"/> populates @r with a dictionary containing user privileges.
    - list_="catalogs"
      <do action_="sql" list_="catalogs" value_"@r"/> populates @r with a list of the names of all available SQL catalogs.
    - list_="columns"
      <do action_="sql" list_="columns" schema_="[SCHEMA]" table_="[TABLE]" value_"@r"/> populates @r with a list of the names of all available columns in the specified table.
    - list_="schemas"
      <do action_="sql" list_="schemas" catalog_="[CATALOG]" value_"@r"/> populates @r with a list of the names of all available schemas to which the user has access in the specified catalog.
    - list_="signatures"
      <do action_="sql" list_="signatures" schema_="[SCHEMA]" tvf_="[FUNCTION]" value_="@r"/> populates @r with a list of all the signatures associated with the table-valued function [FUNCTION].
    - list_="tables"
      <do action_="sql" list_="tables" schema_="[SCHEMA]" value_="@r"/> populates @r with a list of the names of all available tables in the specified schema.
    - list_="tvfs"
      <do action_="sql" list_="tvfs" schema_="[SCHEMA]" value_="@r"/> populates @r with a list of the names of all table-valued functions in the specified schema.
    - list_="views"
      <do action_="sql" list_="views" schema_="[SCHEMA]" value_="@r"/> populates @r with a list of the names of all available views in the specified schema.
    - put_="column"
      <do action_="sql" put_="column" schema_="[SCHEMA]" table_="[TABLE]" objname_="[COLUMN]" data_="{...}"/> updates a column with the specified properties.
    - put_="schema"
      <do action_="sql" put_="schema" objname_="[SCHEMA]" data_="{...}"/> updates a schema with the properties contained in data_.
    - put_="table"
      <do action_="sql" put_="table" schema_="[SCHEMA]" objname_="[TABLE]" data_="{...}"/> updates a table with the specified properties.
    - put_="view"
      <do action_="sql" put_="view" schema_="[SCHEMA]" objname_="[TABLE]" data_="{...}"/> updates a table with the specified properties.
    - reload_="catalog"
      <do action_="sql" reload_="catalog"/> refreshes the entire database catalog in the caller's session.
  - <loop>
    <loop> is a special operation that allows one query to iteratively reference the data from each row in the results of another query.

`reload_="catalog"`

<do action_="sql" reload_="catalog"/> refreshes the entire database catalog in the caller's session.

Description

The 1010data session retrieves SQL metadata at login and caches it throughout the session, just as it caches the underlying MDB metadata. This means that the user will not ordinarily see changes to the metadata after using a <do action_="sql"> transaction until next time they log in. <reload_="catalog"> reloads the cache to ensure that changes are visible to the session. <reload_="catalog"> also clears the MDB query cache to avoid returning stale results from cached queries.

Syntax

<dynamic>
    <do action_="sql" reload_="catalog"/>
</dynamic>