project BLF > class BUserRole > business logic query UsrRolePrim


Parameters


iiUsrRoleIDinteger
icRoleNamecharacter
icUsrLogincharacter


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 namedata typedb fielddescription
tcRoleNamecharacterRole.RoleNameRole Name
tcUsrLogincharacterUsr.UsrLoginLogin
tiUsrRole_IDintegerUsrRole.UsrRole_IDRecord ID


Internal usage


BLF
method BUserRole.ApiSynchronise