Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th September 2017, 12:13
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
Creating and saving a text field [Session Extension]
Baan: Other/Unknown
C/S: None/Unknown

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. This is a sample of my 4GL code:

...
file.tmp = creat.tmp.file$()
ft = seq.open(file.tmp,"w")

text_body = "Sample text"
ret = seq.puts(text_body, ft)
seq.close(ft)

ret = text.write("tdpur400.txtb", "6", "Purchase.", "Order footer.", tdpur400.orno, "", "text", "text", file.tmp)

ret = dal.change.object("tdpur400")
ret = dal.save.object("tdpur400")
if ret <> 0 then
abort.transaction()
ret = dal.get.error.message(error.mess)
message(str$(ret) & " - " & error.mess)
else
commit.transaction()
message("Footer text created for purchase order " & tdpur400.orno)
endif
...

dal.get.error.message return value is 1.
I made a few tries with DAL scripts

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 in my entity (which is a purchase order). Can someone help me?

Thanks,
Alex
Reply With Quote
  #2  
Old 4th September 2017, 14:01
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
I was able to solve it by selecting the record and updating it via db.update, I was hoping to do it via DAL but I couldn't find the way.
Reply With Quote
  #3  
Old 4th September 2017, 15:52
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 730
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
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14


All times are GMT +2. The time now is 07:36.


©2001-2017 - Baanboard.com - Baanforums.com