View Single Post
  #11  
Old 4th September 2017, 11:03
alex.bonutti alex.bonutti is offline
Junior Member
 
Join Date: May 2017
Posts: 11
alex.bonutti is on a distinguished road
Baan: 10.3 - DB: MSSQL - OS: Windows 10
Hi all,
I'm developing a session extension with Tools 10.5 which should create and save a predefined text in purchase order footer. I've tried both via external variable or via database text field, text is created but I'm not able to commit the transaction and save it. I'm using DAL

ret = dal.change.object("tdpur400")
ret = dal.save.object("tdpur400")

or

ret = dal.change.object("tdpur400")
dal.set.field("tdpur400.txtb", text_nr)
ret = dal.save.object("tdpur400")

or even db update funtions

db.update(ttdpur400, db.retry)

but transaction cannot be completed with DAL error

Record ... cannot be saved in table Purchase Orders in company ...

If I commit just the text.write function, a text is correctly saved in the database, but it can't be linked to my entity (which is a purchase order). Can someone help me?

Thanks,
Alex
Reply With Quote