project BLF > class BSystem > business logic query SystBySystAdminUser
query condition
each Syst where
first Usr (outer-join) where
Usr.Usr_ID = Syst.Usr_ID AND
query resultset tqSystBySystAdminUser
field name | data type | db field | description |
tcSystAdminUserPwd | character | Syst.SystAdminUserPwd | System Admin Password |
tiUsr_ID | integer | Syst.Usr_ID | User |
tcUsrLogin | character | Usr.UsrLogin | Login |
Internal usage
BLF