project BLF > class BUserRole > business logic query UsrRolePrim
Parameters
| iiUsrRoleID | integer | |
| icRoleName | character | |
| icUsrLogin | character | |
query condition
each UsrRole where
UsrRole.UsrRole_ID = iiUsrRoleID
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
Role.RoleName = icRoleName
first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND
Usr.UsrLogin = icUsrLogin
query resultset tqUsrRolePrim
| field name | data type | db field | description |
|---|
| tcRoleName | character | Role.RoleName | Role Name |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tiUsrRole_ID | integer | UsrRole.UsrRole_ID | Record ID |
Internal usage
BLF