Help with SalTblPopulate error

forum.centura.team.developer (1998-2005) & forum.sqlwindows (2000-2005)
Mark Steel

Help with SalTblPopulate error

Post by Mark Steel » 13 Jan 2014, 16:05

 Posted by:  Mark Steel <fabrici...@ifs.com.ec> 

Hi all , hoping you=B4re 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 =3D :i_hWndParent.frmShipment.dfsContract
and DELIVER_TO_CUSTOMER_NO =3D :i_hWndParent.frmShipment.dfsCustomerNo
and SHIP_ADDR_NO =3D :i_hWndParent.frmShipment.dfsShipAddrNo
and SHIP_VIA_CODE =3D :i_hWndParent.frmShipment.dfsShipViaCode
and DELIVERY_TERMS =3D :i_hWndParent.frmShipment.dfsDeliveryTerm
and NVL (CUSTOMER_ADDRESS_NAME, '*') =3D NVL=20
=09(:i_hWndParent.frmShipment.dfCustOrdCustomerAddressName2, '*') AND NVL
=09(CUSTOMER_ADDRESS1, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr1, '=
*') AND NVL
=09(CUSTOMER_ADDRESS2, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr2, '=
*') AND NVL=20
=09(CUSTOMER_CITY, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr4, '*') =
AND NVL=20
=09(CUSTOMER_ZIP_CODE, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr3, '=
*') AND NVL=20
=09(CUSTOMER_COUNTY, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr6, '*'=
) AND NVL
=09(CUSTOMER_STATE, '*') =3D NVL (:i_hWndParent.frmShipment.dfsAddr5, '*')=
', TBL_FillAll )
</code>


I am using this query to populate a window child table. Thanks for your hel=
p.

Return to “forum.sqlwindows”

Who is online

Users browsing this forum: No registered users and 0 guests