project BLF > class BSystem > business logic query System
Description
System properties; returns information about he overall system
Parameters
| iiLanguageID | integer | LanguageID of the system |
query condition
each Syst where
Syst.Lng_ID = iiLanguageID
first Domains (inner-join) where
Domains.Domain_ID = Syst.Domain_ID AND
first Lng (outer-join) where
Lng.Lng_ID = Syst.Lng_ID AND
first Usr (outer-join) where
Usr.Usr_ID = Syst.Usr_ID AND
query resultset tqSystem
| field name | data type | db field | description |
|---|
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcSystAdminUserPwd | character | Syst.SystAdminUserPwd | System Admin Password |
| tcSystApplicationId | character | Syst.SystApplicationId | Application ID |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcLngCode | character | Lng.LngCode | Language Code |
| tlLngIsSystemLanguage | logical | Lng.LngIsSystemLanguage | System Language |
| tiSyst_ID | integer | Syst.Syst_ID | Record ID |
| tiLng_ID | integer | Syst.Lng_ID | Language |
Internal usage
BLF
QadFinancials