project QadFinancials > class BState > business logic query StatePrim
Description
Prim query for State with parameters StateID and StateCode
Parameters
| iiStateID | integer | Parameter StateID |
| icStateCode | character | Parameter StateCode |
query condition
each State where
State.State_ID = iiStateID AND
State.StateCode = icStateCode
query resultset tqStatePrim
| field name | data type | db field | description |
|---|
| tiState_ID | integer | State.State_ID | Record ID |
| tcStateCode | character | State.StateCode | State |
| tcStateDescription | character | State.StateDescription | Description |
Internal usage
QadFinancials