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