Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th July 2018, 09:55
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Exclamation update.occ and execute(update.db) in maintain session
Baan: Other/Unknown
C/S: None/Unknown

Hi Friends,

In maintain session before moving to next row when i try to save the current record changes, it was updating only the first row exactly what i need, after that it won't updating the changes in table.

Can you please help me.

Please find the below code

select tdsls999.*
from tdsls999
where tdsls999.item = :tdsls999.item
selectdo
tdsls999.stan = 101
zzsls901.slot = zzyesno.yes
update.occ()
execute(update.db)
endselect
Reply With Quote
Sponsored Links
  #2  
Old 20th July 2018, 07:56
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Multi occurence session with main table

Hi Friends,

please reply how to do the above logic in multi occurrence session before moving to next row the current row have to get save if i changing status as Yes or not
Reply With Quote
  #3  
Old 20th July 2018, 10:04
becks2203 becks2203 is offline
Member
 
Join Date: Jan 2013
Posts: 32
becks2203 is on a distinguished road
Baan: LN - DB: SQL SERVER - OS: WINDOWS SERVER
USE enable.save.on.occ.change() in after.form.read.section()
Reply With Quote
  #4  
Old 20th July 2018, 11:29
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Unhappy

Hi friend

Thanks for the reply. I used it in after.form but it was showing unresolved reference function error. I am using baan 4 c4 version . Can you please given me in detail.

After.form.read.section means after exit the form it reacts right.

I am asking in the current form itself having multiple rows with main table. When i do tab in last field and changing status as Yes then before moving to next row it has to save and update the data.

Regards,
mathew

Last edited by mathew : 20th July 2018 at 11:42. Reason: na
Reply With Quote
  #5  
Old 20th July 2018, 15:33
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,146
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Okay - it what event did you put this action? And you are trying to force an update before moving to the next row? I am going to see if we do something like this with our qkey sessions.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #6  
Old 20th July 2018, 15:42
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,146
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
For something like a single occurrence it looks like in most cases we just wait for the user to hit the save button. So this is qkey - so it calls the baan event first then executes our code. Our code does not have a retry point and just works with in the baan transaction that is on. Let me see if I can find something on a multi-occurrence session.

Code:
main.table.io:								
after.write:
	if tdinv100.kowt = tckowt.stc.correction then
		update.tdudi100()
	endif

after.rewrite:
	|#call
	if tdinv100.kowt = tckowt.stc.correction then
		update.tdudi100()
	endif

before.delete:
	if tdinv100.kowt = tckowt.stc.correction then
		delete.tdudi100()
	endif
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
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
auto save in satellite session mbdave Tools Development 8 17th July 2013 03:59
update.db in maintain session baldie Tools Development 2 5th February 2010 19:12
update.occ() lli-baan Tools Development 4 24th October 2006 11:26
Event handling morpheus Tools Development 7 26th November 2002 05:26


All times are GMT +2. The time now is 01:30.


©2001-2018 - Baanboard.com - Baanforums.com