Help with SalTblPopulate error

[Mark Steel]

Hi all , hoping you´re doing fine. I am new to Centura Team Developer and I have a problem with a call to SalTblPopulate which yields the following error upon compilation: numeric required

The call looks like this

<code>
Call SalTblPopulate( tbwCCustPurchOrder, hSqlTable, 'select ORDER_NO,
LINE_NO,
REL_NO,
LINE_ITEM_NO,
CONTRACT,
STATE,
CUSTOMER_PART_NO,
CATALOG_NO,
CATALOG_DESC,
PART_NO,
CONFIGURATION_ID,
CONDITION_CODE,
CONDITION_CODE_DESC,
DELIVER_TO_CUSTOMER_NO,
DELIVER_TO_CUSTOMER_NAME,
QTY_ASSIGNED,
QTY_PICKED,
QTY_SHIPPED,
SALES_UNIT_MEAS,
BUY_QTY_DUE,
USAGE_ALLOWED,
INPUT_UNIT_MEAS,
INPUT_QTY,
INPUT_CONV_FACTOR,
INPUT_VARIABLE_VALUES,
PLANNED_DELIVERY_DATE,
PLANNED_DUE_DATE,
PROMISED_DELIVERY_DATE,
ROUTE_ID,
ROUTE_ID_DESC,
PLANNED_SHIP_DATE,
PLANNED_SHIP_PERIOD,
QTY_RETURNED,
SELF_BILLING_DB,
DOCK_CODE,
SUB_DOCK_CODE,
REF_ID,
LOCATION_NO,
PROGRAM_ID,
PROGRAM_DESC,
PROJECT_ID,
PROJECT_NAME,
SUB_PROJECT_ID,
SUB_PROJECT_DESC,
ACTIVITY_NO,
ACTIVITY_DESC,
ACTIVITY_SEQ,
C_PROJECT_ID,
C_PROJECT_NAME,
C_SUB_PROJECT_ID,
C_SUB_PROJECT_DESC,
C_ACTIVITY_NO,
C_ACTIVITY_DESC,
C_ACTIVITY_SEQ,
INTERNAL_OR_CUSTOMER_PO_NO,
CUSTOMER_PO_LINE_NO,
CUSTOMER_PO_REL_NO,
SALES_CONTRACT_NO,
WANTED_DELIVERY_DATE,
AVAILABLE_QTY,
CATALOG_TYPE,
SHIP_ADDR_NO,
SHIP_VIA_CODE,
DELIVERY_TERMS,
INTERNAL_PO_NO,
INTERNAL_PO_LINE,
INTERNAL_PO_REL,
RECEIPT_REF,
PUR_QTY_IN_STORE,
QTY_IN_STORE,
REQUISITION_NO,
PO_NO,
REQUISITIONER,
CUSTOMER_ADDRESS1,
CUSTOMER_ADDRESS2,
CUSTOMER_CITY,
CUSTOMER_ZIP_CODE,
CUSTOMER_COUNTY,
CUSTOMER_STATE,
CUSTOMER_ADDRESS_NAME,
RECEIPT_NO
from IFSCMI.C_CUST_PURCH_ORDER
where CONTRACT = :i_hWndParent.frmShipment.dfsContract
and DELIVER_TO_CUSTOMER_NO = :i_hWndParent.frmShipment.dfsCustomerNo
and SHIP_ADDR_NO = :i_hWndParent.frmShipment.dfsShipAddrNo
and SHIP_VIA_CODE = :i_hWndParent.frmShipment.dfsShipViaCode
and DELIVERY_TERMS = :i_hWndParent.frmShipment.dfsDeliveryTerm
and NVL (CUSTOMER_ADDRESS_NAME, '*') = NVL
(:i_hWndParent.frmShipment.dfCustOrdCustomerAddressName2, '*') AND NVL
(CUSTOMER_ADDRESS1, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr1, '*') AND NVL
(CUSTOMER_ADDRESS2, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr2, '*') AND NVL
(CUSTOMER_CITY, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr4, '*') AND NVL
(CUSTOMER_ZIP_CODE, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr3, '*') AND NVL
(CUSTOMER_COUNTY, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr6, '*') AND NVL
(CUSTOMER_STATE, '*') = NVL (:i_hWndParent.frmShipment.dfsAddr5, '*') ', TBL_FillAll )
</code>


I am using this query to populate a window child table. Thanks for your help.