how can i overwrite via extension the data shown in tdsls4100m000
using this sql
Code:
select tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn |,count(*)
from tdsls400
GROUP BY tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn
HAVING count(*) > 1
selectdo
select *
from tdsls400
where tdsls400.ofbp = {:tdsls400.ofbp} and
tdsls400.oamt = {:tdsls400.oamt} and
tdsls400.ddat = {:tdsls400.ddat} and
tdsls400.corn ={:tdsls400.corn}
selectdo
endselect
i tried this in the CDF button i created
Code:
query.extend.select("select tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn", EXTEND_OVERWRITE)
query.extend.from("from tdsls400 GROUP BY tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn HAVING count(*) > 1", EXTEND_OVERWRITE)
but no changes in the overview session
please help im currently stuck 2week on this problem