数据窗囗更新问题
dw_2.ShareData(dw_1)
其中dw_1增加了"SYS_ITEM_WEIGHT"."CO_CODE" = :as_co_code , 经共享后实际语法已经变成了dw_2语法,即不带where 子句,dw_2的更新属性已经去掉(使用PFC),只留下dw_1来更新同一张表。问题是当dw_2中没有数据时可以更新(增加一行),当dw_2中有数据时就不可更新(无论新增行或修改资料):Datawindow dose not have UPDATE capability,大家有没有碰到过此类问题。
附dw_2语法:
SELECT "SYS_ITEM_WEIGHT"."CO_CODE",
"SYS_ITEM_WEIGHT"."CUST_NUM",
"SYS_ITEM_WEIGHT"."ITEM_NUM",
"SYS_ITEM_WEIGHT"."ITEM_TYPE",
"SYS_ITEM_WEIGHT"."ITEM_UNIT",
"SYS_ITEM_WEIGHT"."UNIT_WEIGHT",
"SYS_ITEM_WEIGHT"."EFF_DATE",
"SYS_ITEM_WEIGHT"."UPDATE_CNT",
"SYS_ITEM_WEIGHT"."CREATE_BY",
"SYS_ITEM_WEIGHT"."CREATE_DATE",
"SYS_ITEM_WEIGHT"."UPDATE_BY",
"SYS_ITEM_WEIGHT"."UPDATE_DATE",
"CUSTOMER"."CUST_NAME"
FROM "SYS_ITEM_WEIGHT",
"CUSTOMER"
WHERE ( "SYS_ITEM_WEIGHT"."CO_CODE" = "CUSTOMER"."CO_CODE" ) and
( "SYS_ITEM_WEIGHT"."CUST_NUM" = "CUSTOMER"."CUST_NUM" )