Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
20%
Total votes: 44

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th June 2018, 17:45
Svidos29 Svidos29 is offline
Member
 
Join Date: Oct 2017
Posts: 35
Svidos29 is on a distinguished road
Baan: Baan IV - DB: Onpen Sql - OS: Windows 10
Save record in table
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: Client

hi all,

i'm selecting in insert of a row some values with my personal function. But when i'm saving the row, in ttaad i see ne record without the 3 values that i'm setting. I'm thinking it's because i do not put any db update, but how can i manage it if i'm in the session of the main table that i have to update?
cisli225 is the main table, here down the code. The values to update are cisli225.exmt cisli225.ceno cisli225.txid

Thanks
Quote:
function void calcolo.lettera.intento.disponibile()
{
domain tcamnt tmp.amnt
long count.rows

tmp.amnt = 0
count.rows = 0


select cisli220.pfbp
from cisli220
where cisli220._index1 = {:cisli225.sfcp, :cisli225.msid}
selectdo
select tctax100.*
from tctax100
where tctax100.otof = :cisli220.pfbp
order by tctax100._index4 desc
selectdo
select count(*):count.rows
from tctax100
where tctax100.otof = :cisli220.pfbp
selectdo
endselect
if count.rows = 1 then
select tctax910.*
from tctax910
where tctax910.nreg = :tctax100.nreg.c
and tctax910.bpid = :tctax100.otof
selectdo
tmp.amnt = tmp.amnt + tctax910.amnt
selectempty
cisli225.exmt = tcyesno.yes
cisli225.ceno = tctax100.ceno
cisli225.txid = tctax100.cvat
return
endselect
else
select tctax910.*
from tctax910
where tctax910.nreg = :tctax100.nreg.c
and tctax910.bpid = :tctax100.otof
selectdo
tmp.amnt = tmp.amnt + tctax910.amnt
selectempty
break
endselect
endif

if tmp.amnt < tctax100.amnt.c then
cisli225.exmt = tcyesno.yes
cisli225.ceno = tctax100.ceno
cisli225.txid = tctax100.cvat
return
else
return
endif
commit.transaction()
endselect
endselect
}
Reply With Quote
  #2  
Old 6th June 2018, 20:17
rahul ingale rahul ingale is offline
Member
 
Join Date: May 2011
Location: Mumbai
Posts: 38
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
If you use dal of cisli225 then you can do it in before save object.also you can do it in UI script using with.object.set.do function but you have to select table 225 and update table in normal way.
__________________
IRL
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
Trigger Standard Session from LN Extension sang1285 Tools Development 3 19th March 2017 10:25
Ascertain if a table record is locked when read andy2609 Tools Development 9 10th September 2014 13:59
Maintain Session (main table) update another record in main table sgoupil Tools Development 4 24th September 2010 19:58
Standard Table to Customize Table jaycee99 Tools Development 5 6th November 2008 11:22
tdsls4223m000 keep looking for record in table tccom700. kittyfeng Finance, Invoicing and Integration 0 3rd November 2003 04:25


All times are GMT +2. The time now is 12:32.


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