Hi,

I am looking for a sample script for display session using multiple table, I want use tdsls041,tipcs020,tipcs510,tipcs520,tipcs530,tisfc001, where project number is the key.
I have created a display session with base table as tdsls041 as form 1 and all other tables are different forms like tipcs020 as form 2 etc.
but not able to link them.

Any light.

Regards

The number of rows returned by each table with project key is irregular and unpredicatable. So would suggest you to create some more sessions which are invoked from program based on project value . This is implemented in later versions of Baan as MMT (Multi-main table ) functionality with more user friendlieness.

Thanks for the information,
Just looking for a sample script of display session using any other table.

Regards

Hi Tushar,


One think u can try . make a simple display session using the table tdsls041
and delete the all field from "form" which is not required.
Change the script according the requirement and put the extra field in the form. It will work.

If u send the actual I will develop the session and send it to u.


Regards

Debdas

Hi,
We want to use the following table and their fields,
tdsls040,tccom001,tccom010,tiitm001,tipcs020,tipcs510,tipcs520,tipcs530,tisfc001,tcqms120,tcqms100,tcqms101,tcqms115,tcqms110,tdsls045,tcmcs039

I want to create a display session which named as Sales Order tracking.

the first form of display session speak about sales order (tdsls041),next form (2) speak about project (tipcs020) - link is project no, we are linking sales order with project, 3 form speak about PRP production order, 4th will speak PRP W/H order,5 th will speak PRP Purchase Order, 6th about SFC production, 7th about QA/QC and finaly 8 th will be Despatch.

I have already made this tracking system as print session and it is perfectly fine. now I want to develop the same as display session. that is why looking for a sample script where any one has linked multiple table.

I have already developed one display session With form type 2 (session has 8 form), for sales order (form1) and project (form2) is working fine without any script, for other tables it is not fetching data.
may be my syntax is not correct.
attaching my script code

Thanks

Hi Tushar,

The simplest way is to program in the after read section of main table I/O for all those tables. If you have any display problems, use in before.display for evey field the same functions to read data.

All the choices will work without any additional effort.

Good luck!!

Hi Tushar ,

Currently I am away from Baan and will try to get an illustration tomorrow if possible.

Hi!

I too have the same problem in displaying the fields from the table other than the main table. I have parent, child relationship between the tables. I have generated display session on the master table with form type multiocc + view. I am displaying vendor code wise items. And the other table has all the billing details. So, for each item i have to show all the bills booked.

In my session rather than displaying all the bills for one item, it is showing ony latest bill booked. Meaning, only one bill for one item is displayed on the form. I have kept select query for selecting all the bills in the after.read event of main.table.io section. But, no luck yet.

Please, can anybody suggest me how can i display all the bills for each item.

Reply as soon as possible.

Thanks.

U should use bills transaction table as main table. There must be proper index on that table to support form view .

Alternatively if u want to use the same order or view and use the same main table , u can do so by creating 2 interactive sessions which act in a syncronized manner . e.g. When u start tisfc0102m000 , it actually starts 2 sessions internally (see output of ps in ttstpshell) viz tisfc0102m000 and tisfc0506m000 .

This too can have problems if number of child items to show is more than one screen as there is no direct interaction with child session.

If u have less time then 1st alternative is the right approach . In later versions excellent MMT sessions can be developed .

Hi Hitesh,

Thank you for the reply. I have to display items vendor code wise. So, i cant have my session on bill transaction table.

According to what you told abt creating two interactive sessions. This you are telling for BAAn IV. Since, synchronized sessions are not possible in BAAN IV.

So, can you please explain me solution in some detail.

Thanks.

Syncronized sessions like tisfc0102m000 , tdsls4102s000 etc are possible in B40 . But remember all of the same just different view on same main table . So it may be good time and efforts trying the functionality through syncronized sessions .

Instead u may re-engineer ur logic if possible (say to see bill's in a subsession ). That would be much quick and recommended solution in a limited time frame.

Interactive sessions in baan work with one as main and another as child session . Main session receives all the events / commands and syncronizes the action with child by giving appropriate execute instruction to it . All interactive sessions u c in Baan IV or are on same table with different view of the table.

U need interactive view of 2 different tables . So u need a good command translation mechanisms in these program .

e.g Normal next/ previous / top/last works on main session . Group next/previous ..etc are communicated to child as it's own next /previous.... for same items. U need special command (user.0) to search records in child session. Baan standard search will work only maintable recors .

There are good threads on interactive sessions on this board ,and if all these looks complicated , I would recommend u to re-engineer the functionality .

Interactive sessions are bit complicated. I will re-engineer the logic. Thanks for all the replies.