hardei
28th November 2007, 13:54
Dear frnds,
I am working on baan 5.i want to update order quantity using afs in sales order lines.But at stpapi.save session gets hanged
please the code and advise me
select tdsls401.*
from tdsls401
where tdsls401.item = :tcibd001.item
and tdsls401.oltp <> tdgen.oltp.total
and tdsls401.oqua <> tdsls401.dqua
and tdsls401.orno = "HFSL71344"
order by tdsls401._index9
selectdo
orno = tdsls401.orno
posi = tdsls401.pono
oamt = tdsls401.oqua + 10
stpapi.put.field("tdsls4501m000","tdsls401.orno",tdsls401.orno)
stpapi.put.field("tdsls4501m000","tdsls401.pono",str$(tdsls401.pono))
stpapi.put.field("tdsls4501m000","tdsls401.sqnb","0")
| ret1 = stpapi.change.view("tdsls4501m000",error)
ret1 = stpapi.mark("tdsls4501m000",error)
ret1 = stpapi.synchronize.dialog("tdsls4501m000","modify",error)
stpapi.put.field("tdsls4101s000","tdsls401.oqua",str$(oamt))
stpapi.handle.subproc("tdsls4101s000","tdpcg0240s000","kill")
ret = stpapi.update("tdsls4101s000",true,error)
| error.code = stpapi.get.mess.code("tdsls4101s000",error)
| if (error.code = "tdsls00010") and (error <> "")then
ret = stpapi.save("tdsls4101s000",save.error)
message("%d",tdsls401.oqua)
| endif
stpapi.end.session("tdsls4101s000")
stpapi.end.session("tdsls4501m000")
I am working on baan 5.i want to update order quantity using afs in sales order lines.But at stpapi.save session gets hanged
please the code and advise me
select tdsls401.*
from tdsls401
where tdsls401.item = :tcibd001.item
and tdsls401.oltp <> tdgen.oltp.total
and tdsls401.oqua <> tdsls401.dqua
and tdsls401.orno = "HFSL71344"
order by tdsls401._index9
selectdo
orno = tdsls401.orno
posi = tdsls401.pono
oamt = tdsls401.oqua + 10
stpapi.put.field("tdsls4501m000","tdsls401.orno",tdsls401.orno)
stpapi.put.field("tdsls4501m000","tdsls401.pono",str$(tdsls401.pono))
stpapi.put.field("tdsls4501m000","tdsls401.sqnb","0")
| ret1 = stpapi.change.view("tdsls4501m000",error)
ret1 = stpapi.mark("tdsls4501m000",error)
ret1 = stpapi.synchronize.dialog("tdsls4501m000","modify",error)
stpapi.put.field("tdsls4101s000","tdsls401.oqua",str$(oamt))
stpapi.handle.subproc("tdsls4101s000","tdpcg0240s000","kill")
ret = stpapi.update("tdsls4101s000",true,error)
| error.code = stpapi.get.mess.code("tdsls4101s000",error)
| if (error.code = "tdsls00010") and (error <> "")then
ret = stpapi.save("tdsls4101s000",save.error)
message("%d",tdsls401.oqua)
| endif
stpapi.end.session("tdsls4101s000")
stpapi.end.session("tdsls4501m000")