i used after.update.db.commit in my script but data is not getting saved in table . please tell what is wrong with this code:


after.update.db.commit:


select tdcus104.effd:effd1,tdcus104.dffd:dffd1
from tdcus104
where tdcus104.pcty = {:tdcus104.pcty}
|and tdcus104.effd < {:effd}
order by tdcus104.effd asc
as set with 1 rows
selecteos
tdcus104.dffd = date.num()

endselect
commit.transaction()

This is the forum for development type questions.

Put in a db.update(ttdcus104) in the code. Assuming this table is a different table than what is used in that session.

i want to update data on sqame table on which i am working

Try the db.update. I think I misspoke the first time.