blanchap
1st August 2008, 21:57
Hi all,

anybody know where the session's description and menu's description are stored? I'm creating a session to validate user's access and i need the description.

I've looked in the ttaad and ttadv tables but could not find it.

Thanks

PB

shah_bs
2nd August 2008, 00:12
This is based on BAAN IVc3.

The table is ttadv130 - Language Dependent Descriptions. This will give you the session description (among many others).

The description of the MENU itself is stored in ttadv360 - Menus.

NPRao
4th August 2008, 20:46
Instead of querying the tools table and trying to figure out the VRC derivation tree or the longest label logic, use the Baan standard functions - tt.session.desc() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_runtime_dictionary_information_tt_session_desc) and tt.menu.desc() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_runtime_dictionary_information_tt_menu_desc)

blanchap
12th August 2008, 23:13
Hi all,

thanks for your input for this.

Regards

PB