ABL allows a super tenant to create (with can-create access) and update (with can-write or can-delete access, as appropriate) database records for specified tenants using the following elements:
CREATE statement and BUFFER-CREATE( ) method on a buffer handle — For a multi-tenant table, these ABL elements provide an option for a super tenant to create a database record for a specified tenant, regardless of the effective tenancy. Without this option, these ABL elements create database records owned by the effective tenant.
All record update statements, such as ASSIGN , SET , UPDATE , DELETE , etc. — Regardless of the current effective tenant, ABL remembers the tenancy of all records created in or retrieved from a multi-tenant database. When a super tenant updates database records created for multiple tenants or queried for multiple tenants, ABL ensures that all these record instances are written to or deleted from the table instances owned by the corresponding tenants.
The universal rule is that if a record in a database buffer is owned by a given tenant or tenant group, ABL writes any updates to that record only for the same tenant or tenant group, regardless of the user's effective tenancy.
Note: If data you want to change in multi-tenant tables is updated from temp-tables, or any other internal or external data store outside of the OpenEdge multi-tenant database, you must track the tenancy of any data that is not maintained in database buffers. For more information, see Identifyingtenancy in temp-tables.
CREATE statement and BUFFER-CREATE( ) method on a buffer handle — For a multi-tenant table, these ABL elements provide an option for a super tenant to create a database record for a specified tenant, regardless of the effective tenancy. Without this option, these ABL elements create database records owned by the effective tenant.