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