如何动态改变数据窗口的sql语句
有一数据窗口的sql语句是这样的:
SELECT sfdj.puwei_no,
sfdj.nian,
sfdj.yue,
sfdj.jilajin,
sfdj.sjymd,
wysfmx.feiyong,
wysfmx.jine,
hetong.shichang,
hetong.shichang_no,
hetong.shichangmx,
sfdj.sfdj_no,
sfdj.sf_no,
wysfhz.lsh
FROM sfdj,
wysfmx,
feiyong,
hetong,
wysfhz
WHERE ( wysfmx.feiyong_no = feiyong.feiyong_no ) and
( sfdj.sf_no = wysfmx.lsh ) and
( sfdj.sf_no = wysfhz.lsh ) and
( wysfhz.hetong_no = hetong.hetong_no ) and
( ( sfdj.sjymd >= :as_dates ) AND
( sfdj.sjymd <= :as_datee ) )
我想动态的在最后加一个条件 and (hetong.shichang_no = '0001')
用setsqlselect()语句后返回-1
如何没有( ( sfdj.sjymd >= :as_dates ) AND ( sfdj.sjymd <= :as_datee ) ) 这句时返回是 1
请问是否在动态改变数据窗口的sql语句时原语句中不能有参数.