Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Multi-tenant ABL : Using multi-tenant-enabled sequences : Restrictions for using groups and sequences
 
Restrictions for using groups and sequences
To avoid such problems, you must follow one of the following rules for using sequences with shared and group-configured tables:
*Ensure that all related tables have the same group definitions, with the same tenants defined as members of a given group defined in each table.
*Have grouping at higher levels of join but not at lower levels.
*Generate all foreign keys used in group or shared tables from a shared sequence, guaranteeing that each tenant will generate a unique value.
The best practice while working with group or shared tables is to always use a shared sequence to generate any field values to be used as a foreign key.
For more information on managing sequences and multi-tenant tables with groups, see Managing access to tables with groups.