showstuff11
15th March 2023, 12:07
how can i overwrite via extension the data shown in tdsls4100m000
using this sql

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
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