project BLF > class BBusinessComponent > business logic query BusActivityByCompActCode
Description
BusActivityByCompActCode: query on table BusComponent (with join to BusAct) with parameters on busAct.busActCode and busComp.BusCompCode.
KEEP THIS QUERY AS SIMPLE AS POSSIBLE AS THIS GETS CALLED FROM BCONTROLPROPERTY AND AS THIS IS USED SEVERAL TIMES AS FORM GETS OPEND OR CLOSED.
Parameters
icBusActitvityCode | character | BusActitvityCode |
icBusComponentCode | character | BusComponentCode |
query condition
each BusComponent where
BusComponent.BusComponentCode = icBusComponentCode
each BusActivity (inner-join) where
BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND
BusActivity.BusActivityCode = icBusActitvityCode
query resultset tqBusActivityByCompActCode
field name | data type | db field | description |
tiBusActivity_ID | integer | BusActivity.BusActivity_ID | Record ID |
tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
tiBusComponent_ID | integer | BusComponent.BusComponent_ID | BusComponent_ID |
tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
Internal usage
BLF