ADD-FIELDS-FROM() method
- Last Updated: January 22, 2026
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
|
You can also use this method as many times as you need to in order to add fields from one
or more additional tables to a temp-table that you have already started to build using
the CREATE-LIKE() or another ADD-FIELDS-FROM()
method.
As with the CREATE-LIKE() method, you pass either the source table
handle or an expression representing its name. If you want to exclude some fields from
being copied into the temp-table definition, pass a comma-separated list of these field
names as the optional second argument. If you add a field whose name is already in the
target temp-table, the AVM ignores the duplicate field and does not add it to the
temp-table.
SalesRep table except the
MonthQuota and Region fields to the fields from
the Customer table already in the temp-table:
|
Both the Customer and SalesRep tables have a
SalesRep field with the SalesRep’s initials.
Because this field is already in the temp-table from the Customer
table, it is not added from the SalesRep table, and no error
results.