Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
I manage and monitor my Baan server/application with
HP Openview
7%
IBM Tivoli
14%
BMC Patrol
2%
Nagios
11%
Other
30%
What are you talking about?
37%
Total votes: 120

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th March 2008, 15:22
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Question single occ field in multioccurence form
Baan: Baan IVc4
C/S: Client

Hi,
I have a multioccurence session of form type 3 with 1 view field and I have a single occ field that I need to maintain against all records for the same view field but I also need this field to be modifiable.
Now when I define it as a single occ field it does'nt accept input which is logical but when I make it part of Index then I am not able to modify it later.
So how can I make it single occurence but yet modifiable and I need to update it against each occurence of the view field as well.

Pls help.
Reply With Quote
  #2  
Old 19th March 2008, 17:40
zardoz's Avatar
zardoz zardoz is offline
Guru
 
Join Date: Jan 2003
Location: Torino, Italy
Posts: 383
zardoz is on a distinguished road
Baan: Triton 2, Triton 3, Baan IV, Baan ERP, Baan LN - DB: Oracle, Tbase, MS Sql - OS: Unix, Windows
Use a temporary field, define it in the form as "Input Only" so isn't in the normal flow of input fields, then use a user choice (adding also the button in the form if you want) to change values in that field.
After that, you only have to update all the records with this value.
__________________
My company
Reply With Quote
  #3  
Old 20th March 2008, 04:55
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Other possible solutions (screen shot attached)

Quote:
Originally Posted by zardoz View Post
Use a temporary field, define it in the form as "Input Only" so isn't in the normal flow of input fields, then use a user choice (adding also the button in the form if you want) to change values in that field.
After that, you only have to update all the records with this value.
Thanks for your suggestion but I don't want to complicate things for the user by providing a button etc. ,infact I want my form to remain as shown in the screen shot attached and I also want to display the "valid date" (single occ) field as it is which won't be possible if I use a temporary form field.

Looking fwd to any other possible solutions
Attached Files
File Type: rtf screen.rtf (2.45 MB, 47 views)
Reply With Quote
  #4  
Old 20th March 2008, 05:06
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Question

Also,when I use a temporary field as "Input Only" (single occ) it does'nt take any input ..so how do I make it accessible to the user?
Reply With Quote
Sponsored Links
  #5  
Old 20th March 2008, 05:13
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Ok I got your point now..actually I was unfamiliar wth "Input Only" field..
Thanks, I shall try it and get back.
Reply With Quote
  #6  
Old 20th March 2008, 05:31
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Question

Can you pls help me on how to save this temporary field value against all occurences ?
Reply With Quote
  #7  
Old 20th March 2008, 06:54
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Unhappy

Hi,I am able to update the records now using your solution but when I use the 'Input Only' field on the form and input some value in it using the 'input()' function,I need to do it in after field section of the some other field which can be:
1. the previous field (which is single occ)---In this case when I navigate to some other set of records ,their value does'nt get refreshed but dislays the previous set values.

2. some other field (all others are multi occ)--here when I start the session I get the input directly to my "Input Only field" and have to press tab for each filled occ. in order to display those.

pls guide me on how to get over these.
Reply With Quote
  #8  
Old 21st March 2008, 12:34
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
How about some screen shots and a copy of the code. That will better help us understand what the problem is. I have never tried this so I do not have a ready made suggestion.
__________________
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
  #9  
Old 21st March 2008, 13:17
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Hi Mark...I have posted the screen shots in a previous post but here 2 i needed to work around by defining that field (valid date) as multi occ but making it active 4 only 1st occ and updating it against all other occurences...so the user does'nt have 2 input it again.
But still I would like to do it in a better way so plz suggest
Reply With Quote
  #10  
Old 21st March 2008, 13:30
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well I do not have a better suggestion - the only places that I update all occurances on a multi-occurance table I use sub-sessions to prompt for the input. In most cases I ask for more than 1 or 2 fields. So I give them a button, launch a subsession and then apply the change. See the attached - in one chase they get to change part of the index on one table - but only one record at a time(changing the warehouse). In the second example after they load records from a file I allow them to do a mass change on the pegging information. I do my best to keep it simple, even if it would be cleaner to just ask for something on the session directly. I do not do this a whole lot, but a few places I can not avoid it.
Attached Images
File Type: jpg Image1.jpg (144.2 KB, 42 views)
File Type: jpg Image2.jpg (146.6 KB, 28 views)
__________________
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
  #11  
Old 21st March 2008, 14:47
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Attached is the code from the parent and 1 of the child sessions. I had no choice on how I solved the customers request. If I had it my way there would be two separate sessions - one for closed production orders and one for non-closed orders. As it is the parent session is a single occurance session for tisfc001 and the child(in this case) is for tisfc010. So depending on the order status I have to launch the appropriate child session. I am not happy with any of the code on these two (or 5 if you include all the child sessions for the two different tables; tisfc010 and tiudi010). I even left some of the stuff in where I have played with things. I do not recommend this unless you have no choice. Baans session which typically use a single occurance at the bottom with a multi-occurance session at the top are much cleaner. This works, for the most part, but I still do not like it.
Attached Images
File Type: jpg Image4.jpg (85.3 KB, 35 views)
Attached Files
File Type: cln parent.cln (6.8 KB, 28 views)
File Type: cln child.cln (5.7 KB, 21 views)
__________________
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
  #12  
Old 22nd March 2008, 15:24
baan1612 baan1612 is offline
Member
 
Join Date: May 2007
Posts: 89
baan1612 is on a distinguished road
Baan: baan 4c4 - DB: oracle - OS: windows 2000
Talking

Hi Mark...thnx 4 ur efforts and valuable suggestions...i have done in the way i posted above n its working fine but ur inputs would b useful in future.
Reply With Quote
  #13  
Old 22nd March 2008, 18:47
Ankita Ankita is offline
Member
 
Join Date: Dec 2007
Posts: 43
Ankita is on a distinguished road
Baan: IV c4 - DB: Informix - OS: Sun Solaris
Hi Mark,

Can u tell me that in your session how is it possible to show both parent and child sessions on a single session? In Baan IV is it possible? Or Is it simply you put single-occ fields on the multi-occ session?

Thanks.
Reply With Quote
  #14  
Old 22nd March 2008, 21:21
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Quote:
Originally Posted by Ankita View Post
Hi Mark,

Can u tell me that in your session how is it possible to show both parent and child sessions on a single session? In Baan IV is it possible? Or Is it simply you put single-occ fields on the multi-occ session?

Thanks.
Yes - this is 4c4 so it is possible. The top session is a single occurance form and the bottom is a multi-occurance form. What you do is create something like 12 lines for the single occurance form - make sure the window is at the top of the form. Then on the child session you create the form on the last 12 lines of the form - in other words more the form to the botton of the screen. Then in parent session set sattr.combined variable in the scripts like in my example. The one problem I have with this is that sometimes the child form does not appear - so you hit the maximize button, save and exit - then rerun the session and it is fine again. I have not figured that out yet. Again I do not like this solution, but it seems to work most of the times.
__________________
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
  #15  
Old 8th February 2010, 11:28
ysovva ysovva is offline
Newbie
 
Join Date: Feb 2008
Posts: 2
ysovva is on a distinguished road
Baan: BaaN V - DB: Oracle 10 - OS: NT
The function: single.fields.on.mocc.form("tablefield") can help to care data for special record (not for all marked or appearing on screen records). The example of this function I didn't find in BaaN V, neither in BaaN VI, but does exist in BaaN IV in the Maintain BOM session.
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
Array as a form field in Multi occ form mgakhar Tools Development 10 1st November 2007 05:04
Form Field Order Eddie Monster Tools Development 3 23rd August 2006 19:58
Query on multioccurence form field bigjack Tools Development 8 29th May 2006 13:15
Single occurrence fields on mutlioccurrence form swanandp Tools Development 1 15th November 2004 13:06
Problems with Display form field pjohns Tools Development 3 16th October 2002 14:37


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


©2001-2010 - Baanboard.com - Baanforums.com