getcolumnname函数有关问题
getcolumnname函数问题
dw_1.getcolumnname()
不论我点到数据窗口的哪一列,这个函数始终返回dw_1的第一列列名.
数据窗口的sql:
select 0 as is_select,
h.createdate,
pc.cstcode
from scm_salbill_hdr_rpt_v h,
bpm_bill_def b,
pub_clients pc,
pub_waredict pw,
wms_outbound_hdr w
where h.OWNERID = 30
and h.flowid = b.flowid
and b.statflag1 = 'SAL01'
and h.goodid = pw.goodid
and h.cstid = pc.cstid
and h.id = w.salbillid(+)
and trunc(h.createdate) between to_date(:s, 'yyyymmdd') and to_date(:e,'yyyymmdd')
and pc.cstcode=:c
and not exists
(select 1
from kp_ld_record k
where k.cstid = h.cstid
and k.billno = h.billno
and k.w_id = w.id)
union all
select 0 as is_select,
pc.cstcode,
pc.dname
from KP_GIFTS_BILL_HDR h,
kp_gifts_bill_dtl d,
pub_clients pc,
KP_GIFTS_WAREDICT kw,
scm_salbill_hdr sh
where h.ownerid = 30
and h.billtype IN(30,70)
and h.id = d.hdrid
and d.giftsid = kw.giftsid
and d.salbillno = sh.billno(+)
and h.cstid = pc.cstid
and trunc(h.createdate) between to_date(:s, 'yyyymmdd') and to_date(:e,'yyyymmdd')
and pc.cstcode = :c
and not exists (select 1
from kp_ld_record k
where k.cstid = h.cstid
and k.billno = h.billno)
dw_1.getcolumnname()始终返回'is_select'.请问是怎么回事?
------解决方案--------------------
没有获取焦点吧？
taborder 为0 ？
------解决方案--------------------
楼上说的是一种可能，
不过我一般不这么干，直接在dw的clicked事件中用dwo.name取，这样可以忽略焦点的问题
dw_1.getcolumnname()
不论我点到数据窗口的哪一列,这个函数始终返回dw_1的第一列列名.
数据窗口的sql:
select 0 as is_select,
h.createdate,
pc.cstcode
from scm_salbill_hdr_rpt_v h,
bpm_bill_def b,
pub_clients pc,
pub_waredict pw,
wms_outbound_hdr w
where h.OWNERID = 30
and h.flowid = b.flowid
and b.statflag1 = 'SAL01'
and h.goodid = pw.goodid
and h.cstid = pc.cstid
and h.id = w.salbillid(+)
and trunc(h.createdate) between to_date(:s, 'yyyymmdd') and to_date(:e,'yyyymmdd')
and pc.cstcode=:c
and not exists
(select 1
from kp_ld_record k
where k.cstid = h.cstid
and k.billno = h.billno
and k.w_id = w.id)
union all
select 0 as is_select,
pc.cstcode,
pc.dname
from KP_GIFTS_BILL_HDR h,
kp_gifts_bill_dtl d,
pub_clients pc,
KP_GIFTS_WAREDICT kw,
scm_salbill_hdr sh
where h.ownerid = 30
and h.billtype IN(30,70)
and h.id = d.hdrid
and d.giftsid = kw.giftsid
and d.salbillno = sh.billno(+)
and h.cstid = pc.cstid
and trunc(h.createdate) between to_date(:s, 'yyyymmdd') and to_date(:e,'yyyymmdd')
and pc.cstcode = :c
and not exists (select 1
from kp_ld_record k
where k.cstid = h.cstid
and k.billno = h.billno)
dw_1.getcolumnname()始终返回'is_select'.请问是怎么回事?
------解决方案--------------------
没有获取焦点吧？
taborder 为0 ？
------解决方案--------------------
楼上说的是一种可能，
不过我一般不这么干，直接在dw的clicked事件中用dwo.name取，这样可以忽略焦点的问题