View Single Post
  #3  
Old 4th September 2017, 14:52
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 728
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Also for an update via the DAL you need to select the record:
Code:
select  tdpur400.*
from    tdpur400 for update
where   tdpur400.orno = :tdpur400.orno
as set with 1 rows
selectdo
        ret = dal.change.object("tdpur400")
        dal.set.field("tdpur400.txtb", text_nr)
        ret = dal.save.object("tdpur400")
endselect
Reply With Quote