Table of contents



Official Content

Defines the Base Table of the related command or statement.

Appears to solve some problems of ambiguity in the determination of the base table (when there are several minimum extended tables containing the command attributes) or when you want another Base Table, different from the one that would be determined by the attributes appearing in the rest of the command. It is also used to improve the specification time of complex reports; however, an indiscriminate use is not recommended. The disadvantage of using this clause when it isn’t necessary is that it ties the code a little more to the design of the Tables.

Syntax

Defined by <Att1,...,AttN>

Where:
Att1,...,AttN 
     List of attributes to determine the related Base Table.

Description

This command allows the user to define the Base Table of a For Each command, New command or Data Provider group explicitly. When defining Procedures/Reports/Work Panel, it is usual for attributes in commands to determine the Base Table. Sometimes, commands within the command do not determine exactly the Base Table (i.e. more than one table can be the Base Table), so it is necessary to declare it explicitly using this command. The attribute list will determine the base table with higher priority.

Notes:

  • This clause can only be specified immediately after a For each, Where, or other Defined by command.
  • The use of the 'Defined by' clause remarkably improves the program specification time, especially in large applications and in For Each or Data Provider groups with large extended tables.

See Some considerations on the Defined by clause in For each or Data Provider.

Scope

Commands: For Each commandData Provider group

See Also

For Each command
Where clause

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant