swanandp
24th March 2005, 15:27
I have written AFS for sales order line. My code is as follows:

stpapi.put.field("tdsls4501m000","tdsls401.orno",strip$(global.orno))
ret.find = stpapi.change.view( "tdsls4501m000",eror.mess)
ret.syc.dlg = stpapi.synchronize.dialog("tdsls4501m000","add",eror.mess)
stpapi.put.field("tdsls4101s000","tdsls401.pric",str$(tdhpc926.pric))
stpapi.put.field("tdsls4101s000","tdsls401.cfrw",tdhpc926.cfrw)
stpapi.put.field( "tdsls4101s000", "tdsls401.item.segment.1",tdhpc926.item(1;9))
stpapi.put.field "tdsls4101s000", "tdsls401.item.segment.2",str$(tdhpc926.item(10;38)))
stpapi.put.field("tdsls4101s000","tdsls401.prdt",str$(tdhpc926.rdta))stpapi.put.field("tdsls4101s000","tdsls401.oqua",str$(tdhpc926.oqua))
stpapi.put.field("tdsls4101s000","tdsls401.corp",tdhpc926.cpos)
afs.insert = stpapi.insert("tdsls4501m000",true,error.lines)

stpapi.end.session("tdsls4101s000")
stpapi.end.session("tdsls4501m000")

I am getting unknow SQL id error when I end the AFS for tdsls4501m000.
However lines are getting created properly.

Can anyone tell me why this error comes and how it can be resolved.

Baan details SP 15
PortingSet 7.1d.05

I cannot go for a SP or portingset upgrade. If you have any solution then let me know

Regards,
Swanand

mark_h
24th March 2005, 15:40
Make sure you have the latest patches for stpapi libraries and latest version of the session. It is probably a problem with the stpapi libraries - at least that is what I have seen before.

Mark