SELECT WZPM_DICT.pmdm,
WZPM_DICT.wzmc,
WZPM_DICT.jldw,
WZPM_DICT.zbsl,
SFPZ_D_WMS.zl,
SFPZ_D_WMS.xhdm
FROM WZPM_DICT,
SFPZ_D_WMS,
SFPZ_M_WMS,
DW_DICT
WHERE ( WZPM_DICT.pmdm = SFPZ_D_WMS.pmdm ) and
( SFPZ_D_WMS.pzid = SFPZ_M_WMS.pzid ) and
( SFPZ_M_WMS.fwdw = DW_DICT.dwmc ) and
( ( DW_DICT.dwdm = :dwdm ) AND
( SFPZ_M_WMS.fwdw like :fwdw ) AND
( SFPZ_M_WMS.kfdm = :kfdm ) AND
( SFPZ_M_WMS.kfdm = :kfdm1 ) AND
( SFPZ_M_WMS.sflx = :sflx ) AND
( convert(char(10),SFPZ_M_WMS.kcrq ,21) like :kcrq ) AND
( convert(char(10),SFPZ_M_WMS.sfrq,21) like :sfrq ) )
ORDER BY WZPM_DICT.pmdm ASC
在dw_2要显示查询的datawindow的sql语句是这样的。
在它的datawindow的open事件中是:
integer dwdm,sflx,em
string fwdw,kfdm,kfdm1,kcrq,sfrq
dwdm=integer(sle_1.text+'%')
fwdw=ddlb_2.text+'%'
kfdm=sle_2.text+'%'
kfdm1=ddlb_3.text+'%'
sflx=integer(ddlb_4.text+'%')
kcrq=sle_3.text+'%'
sfrq=sle_4.text+'%'em = integer(dw_1.getitemstring(getrow(dw_1),"pzid"))dw_2.setfilter("SFPZ_D_WMS_pzid=em")
dw_2.clear()
dw_2.retrieve(dwdm,fwdw,kfdm,kfdm1,sflx,kcrq,sfrq)
但在运行时,发出Expression is not valid.
WZPM_DICT.wzmc,
WZPM_DICT.jldw,
WZPM_DICT.zbsl,
SFPZ_D_WMS.zl,
SFPZ_D_WMS.xhdm
FROM WZPM_DICT,
SFPZ_D_WMS,
SFPZ_M_WMS,
DW_DICT
WHERE ( WZPM_DICT.pmdm = SFPZ_D_WMS.pmdm ) and
( SFPZ_D_WMS.pzid = SFPZ_M_WMS.pzid ) and
( SFPZ_M_WMS.fwdw = DW_DICT.dwmc ) and
( ( DW_DICT.dwdm = :dwdm ) AND
( SFPZ_M_WMS.fwdw like :fwdw ) AND
( SFPZ_M_WMS.kfdm = :kfdm ) AND
( SFPZ_M_WMS.kfdm = :kfdm1 ) AND
( SFPZ_M_WMS.sflx = :sflx ) AND
( convert(char(10),SFPZ_M_WMS.kcrq ,21) like :kcrq ) AND
( convert(char(10),SFPZ_M_WMS.sfrq,21) like :sfrq ) )
ORDER BY WZPM_DICT.pmdm ASC
在dw_2要显示查询的datawindow的sql语句是这样的。
在它的datawindow的open事件中是:
integer dwdm,sflx,em
string fwdw,kfdm,kfdm1,kcrq,sfrq
dwdm=integer(sle_1.text+'%')
fwdw=ddlb_2.text+'%'
kfdm=sle_2.text+'%'
kfdm1=ddlb_3.text+'%'
sflx=integer(ddlb_4.text+'%')
kcrq=sle_3.text+'%'
sfrq=sle_4.text+'%'em = integer(dw_1.getitemstring(getrow(dw_1),"pzid"))dw_2.setfilter("SFPZ_D_WMS_pzid=em")
dw_2.clear()
dw_2.retrieve(dwdm,fwdw,kfdm,kfdm1,sflx,kcrq,sfrq)
但在运行时,发出Expression is not valid.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货