project QadFinancials > class BLayer > business logic query LayerPrim
Description
Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.
Parameters
| iiLayerId | integer | LayerId |
| icLayerCode | character | Layer Code |
query condition
each Layer where
Layer.Layer_ID = iiLayerId and
Layer.LayerCode = icLayerCode
query resultset tqLayerPrim
| field name | data type | db field | description |
|---|
| tcLayerDescription | character | Layer.LayerDescription | Description |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tiLayer_ID | integer | Layer.Layer_ID | Record ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Layer) |
Internal usage
QadFinancials