project BLF > class BRole > business logic query RolePrim
Description
RolePrim; converts the logical prim-key into the physical prim-key and vice-versa
Parameters
| iiRoleID | integer | RoleId |
| icRoleName | character | RoleName |
query condition
each Role where
Role.Role_ID = iiRoleID AND
Role.RoleName = icRoleName
query resultset tqRolePrim
| field name | data type | db field | description |
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleName | character | Role.RoleName | Role Name |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Role) |
Internal usage
BLF
QadFinancials