Base Table

Official Content
This documentation is valid for:

See Extended Table.

base table is any table in the database where you are positioned and working at a certain time, for example for retrieving or modifying its data.

When you execute a Transaction object with a single level, it has one associated base table

When you work with a Transaction object with more than one level, each level has an associated base table.

Also, when you define queries (a listing, for instance), you will be navigating a specific base table.

Some examples:

  • For each command: The base table of a For Each is the table navigated, as determined by GeneXus. Even though a For Each doesn’t navigate only one table, but also an Extended Table, the For each has a base table that is navigated, and its Extended Table is accessed to retrieve or update data (or filter by an attribute that belong to the extended table, etc.).
     
  • New: Every time GeneXus finds a “new” command, it must identify the table where the record will be inserted. The table identified to make the insertion in it, is the base table in this case.
     
  • Data Provider: The base table of a Data Provider is the table navigated io charge a collection, or an instance in memory, etc. Even though a Data Provider doesn’t navigate only one table, but also an Extended Table, the Data Provider has a base table that is navigated and its extended table is accessed (for the purpose of retrieving data or filtering by an attribute that belong to the extended table, etc.).
     
  • Grid: The base table of a grid is the table navigated to retrieve and display in the grid the required attributes. Even though not only one table is browsed, but also an Extended Table, the grid has a base table that is navigated, and its extended table is accessed (for the purpose of retrieving data too or filtering by an attribute that belongs to the extended table, etc.).   
     
  • Formula: The base table of a formula is the table that is going to be navigated in order to evaluate it (to calculate its result value). 
     
  • Subtype Group object: The base table of a subtype group is the table whose complete primary key is included in the subtype group definition, as the key of the group (the subtype group must include a subtype attribute or a set of subtype attributes, whose corresponding supertype attributes make up the primary key of an existing table, which it is the base table of the group).