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

Maintenance Warning will be unavailable on Saturday 26th of January from 12hrs until Sunday 27 of January at 18hrs (GMT+1) due to infrastructure upgrades.

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 42

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 20th April 2005, 01:19
tools123 tools123 is offline
Senior Member
Join Date: Aug 2002
Posts: 146
tools123 is on a distinguished road
Baan: 4c4 - DB: informix - OS: unix
Question Reorder fields in a type 3 display session

I have a display session based on main table say A with one view field, item.

on the occurances records, I have fields from another table B in addition to those from A. One of those fields is a date field. I was wondering if there is a Good way to order / reorder records by this date field (just the occurances records).Any kind of dynamic reorder / dyanamic index?

Addition of this field in the the table A is an option but would like to avoid if possible.

Reply With Quote
Sponsored Links
Old 20th April 2005, 17:03
lbencic's Avatar
lbencic lbencic is offline
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
Hmm yea, in Baan IVc4 you can't really sort on anything other than the main table index.

How are you linking table B to table A? Would it not have the same index as A, since you have a 1 to 1 relationship it seems like? (Maybe an example with your table indexes and relationship would help if I am mis understanding that). One suggestion, can you just make the main table B instead? And change all the view fields on the form to B instead of A. You can then use the sort from B....I may be missing or assuming critical issues, show us your table structures.. You could update table A based on updates to Table B if you need this to be a maintain...that could get messy as well, but it sounds like you just want the display.

Or..make a report that sorts like that and add a button to print it.
Reply With Quote
Old 20th April 2005, 19:08
tools123 tools123 is offline
Senior Member
Join Date: Aug 2002
Posts: 146
tools123 is on a distinguished road
Baan: 4c4 - DB: informix - OS: unix
Thanks for your suggestions.

I am still weighing the options of moving the date field over to the other table, changing the session's main table ( this I had tried already but becomes more complex once the updates are considered- btw this is not a strictly display session). Thanks
Reply With Quote

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
Disappearing fields in combined session ronny1 Tools Development 0 29th April 2004 15:36
Baan & Connectware Driver Hangs Rajasekhar Tools Administration & Installation 2 18th February 2004 22:32
CUMULATING + FILTERING records in DISPLAY SESSION en@frrom Tools Development 21 25th August 2003 17:16

All times are GMT +2. The time now is 11:34.

©2001-2018 - -