Identifying database record tenancy
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Identifying database record tenancy
A super tenant can get information about the tenancy of a database record using these ABL built-in elements:
-
IS-MULTI-TENANTattribute on a buffer handle — ReturnsTRUEif the current record referenced by the specified buffer handle is in a multi-tenant table. -
BUFFER-TENANT-NAMEandBUFFER-TENANT-IDfunction — Returns the tenancy of the current record in the specified buffer. -
BUFFER-TENANT-NAMEandBUFFER-TENANT-IDattribute on a buffer handle — Returns the tenancy of the current record referenced by the specified buffer handle.
Note: You cannot use the
BUFFER-TENANT-NAME or BUFFER-TENANT-ID functions
or attributes in the WHERE option of the record
phrase if these functions and attributes work on the same record
buffer that is specified by the record phrase. Instead, you can
use these functions and attributes in the TENANT-WHERE option
of the same record phrase. For more information, see TENANT-WHERE option of the record phrase.