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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd August 2006, 14:51
Eddie Monster's Avatar
Eddie Monster Eddie Monster is offline
Guru
 
Join Date: Nov 2001
Location: Pittsburgh, PA, USA
Posts: 343
Eddie Monster is on a distinguished road
Baan: Baan IVc4 - DB: MS SQL Server 2008 R2 - OS: MS Server 2008 R2
Form Field Order
Baan: Baan IVc4
C/S: None/Unknown

I have a customized session with a form type 2. 10 occurences show up on the session at a time and there are three fields per occurence which are display and two fields per occurence which are maintainable by the user. The two maintainable fields belong to the main table associated with the session.

I have just added two additional form fields which hold variables the user will populate when they start the session (these fields are needed when the user clicks 'continue' and the records are processed by the session script). The problem I'm having is that the form field order goes in the following order:

Variable field one {TAB}
Variable field two {TAB}
Occurance 1 field one {TAB}
Occurance 1 field two {TAB}
Variable field one {TAB}
Variable field two {TAB}
Occurance 2 field one {TAB}
Occurance 2 field two {TAB}

The desired behavior would be the following:

Variable field one {TAB}
Variable field two {TAB}
Occurance 1 field one {TAB}
Occurance 1 field two {TAB}
Occurance 2 field one {TAB}
Occurance 2 field two {TAB}

I have tried several different configurations of the field order when maintaining the form and have been unsuccessful. I have also searched the forums and haven't found anything useful either. The only thing I did find which I may be able to use is the to.field() function, but the sessions flow is quirky (users would not approve).

Does anyone else have any suggestions? Due to the nature of the data I cannot make the two variable fields part of my main table and use a form type 3.

Thank you for any help.
Reply With Quote
  #2  
Old 23rd August 2006, 16:18
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
I've done similar. Try making it 'Single Occurance' and Field Type = Input Only. Also check 'mandatory' and will need to fill it before they leave, if you want. Then, use the command 'input' to get to it on start up. I used this code

Code:
form.1:
init.form:
        input("my.single.occ.variable")
        execute(modify.set)                       |* takes them to modify the first occ
Reply With Quote
  #3  
Old 23rd August 2006, 17:14
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Crap - this looks a whole lot easier than the one time I did this. What I did was in the after.input I set a variable to true. Then as long as I was in add.set mode and this variable was true I set attr.input to false. It took me a while to figure which section to use - then the user decided they want the field for each record.
__________________
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
Sponsored Links
  #4  
Old 23rd August 2006, 19:58
Eddie Monster's Avatar
Eddie Monster Eddie Monster is offline
Guru
 
Join Date: Nov 2001
Location: Pittsburgh, PA, USA
Posts: 343
Eddie Monster is on a distinguished road
Baan: Baan IVc4 - DB: MS SQL Server 2008 R2 - OS: MS Server 2008 R2
You are a true Guru!

lbencic,

Based on your input here is what I had to do. This customized session is based on the need for multi-line so I did the following:
  • Kept the form at type 2 (multi-occ + main)
  • Changed the form types for those two 'variable' fields to "Input Only"
  • In the session script under form.1-init.form section:
    • execute(find.data) (so all my occurences and their 'extra' data from other tables displayed first thing)
    • input("single.occ.one")
    • input("single.occ.two")

Everything works fine now! Thank you very much!
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
Query on multioccurence form field bigjack Tools Development 8 29th May 2006 13:15
order by field in form shuzheng Tools Development 6 25th October 2005 12:32
Baan Performance Tracing Questions thomas_b Performance & Tuning 5 25th July 2005 11:22
Problems with Display form field pjohns Tools Development 3 16th October 2002 14:37
Mandatory field at form level BaanTech Tools Development 3 20th September 2002 16:14


All times are GMT +2. The time now is 15:25.


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