Hi All , I want to use tools table in program script. But when I define tool tables in program script and compile script, it could't recognize tools table like table ttadv200 Does anyone know any solution to this ?

Thanks ...

you have to declare them with a t in the beginning:
table tttadv200

Oh my god ! I should be blind. I will try it again . Thank you !

And use compnr specfication for 0 company in SQL on this tables. Then u can access these tables.

Do u need to use the tools table as main table.

Yes I need to use tools table as main table . I wanne generate session that will content all baan users list in display session. How can I generate it ?

AFAIK u can not generate session on a tools table. However if u wish to display certain info from tools table as per ur convenience , u may do so using pre-defined variable main.table$.

In before program section define the pre-defined variable main.table$ as tools table. Remember to switch to 0 company in before program and return to the original company before closing the display session . Assign tools table values to form field variables as defaults or write it in before.display section.

Thanks Hitesh , I will try it .

Thanks Hitesh It works great. Thanks for your suggestion.

Ur welcome . BTW why dont u use the existing baan session ttaad2500s000 to display users.