project BLF > class BUser > business logic query UsrDomainPrim
Parameters
icUsrLogin | character | |
icDomainCode | character | |
iiUsrDomainId | integer | |
query condition
each UsrDomain where
UsrDomain.UsrDomain_ID = iiUsrDomainId
first Domains (inner-join) where
Domains.Domain_ID = UsrDomain.Domain_ID AND
Domains.DomainCode = icDomainCode
first Usr (inner-join) where
Usr.Usr_ID = UsrDomain.Usr_ID AND
Usr.UsrLogin = icUsrLogin
query resultset tqUsrDomainPrim
field name | data type | db field | description |
tcDomainCode | character | Domains.DomainCode | Domain |
tiUsrDomain_ID | integer | UsrDomain.UsrDomain_ID | Record ID |
tcUsrLogin | character | Usr.UsrLogin | Login |
Internal usage
BLF