project QadFinancials > class BLayer > business logic query LayerByLayerIDLayerTypeCode
Description
LayerByLayerIDLayerTypeCode
Parameters
| iiLayerID | integer | |
| icLayerTypeCode | character | |
| icLayerCode | character | |
query condition
each Layer where
Layer.Layer_ID = iiLayerID AND
Layer.LayerCode = icLayerCode AND
Layer.LayerTypeCode = icLayerTypeCode
query resultset tqLayerByLayerIDLayerTypeCode
| field name | data type | db field | description |
|---|
| tiLayer_ID | integer | Layer.Layer_ID | Record ID |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tcLayerDescription | character | Layer.LayerDescription | Description |
| tlLayerIsActive | logical | Layer.LayerIsActive | Active |
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Layer) |
Internal usage
QadFinancials