Hi

I have a question on programming principles. I heard some where that, while coding we are not supposed to used tables related to tt for doing queries. For example, if I want company data, instead of using ttaadxxx we have to use tccom000 like that. Is it a valid principle I heard? If yes, why it was proposed and violating this rule can impact in what kind of set up?

I do not know about baan 5, but in 4c4 I read the tools tables in several different places. At one time I even had a script to go thru and update some domains. I see no problem with reading the tools table as long as you are aware of the information and how it is formatted. I would not recommend updating any of the tools tables, without being extra careful and really understanding the impact. Just my opinion.

The rule is that you are not supposed to access the tt tables directly. The data structure or meaning could be changed with any update. Even though (major) changes are unlikely.

For a lot of needs, there is some function, including the 'tt.*' functions, that will provide you with the information that you are looking for.

I agree with Mark that updates to tools tables should be avoided. If you create data corruption that way, then support will not assist you.

If you are just reading the tables for some information, then the risk of some impact is small.

As a conclusion, if there is a function to get the data, then use it.

I agree with all comments . Technically there is no bar using tt tables in script . But that should be a last resort even for just read-only query . Practically there is function for everything .

Beyond that an expert hands can definitely make use of tools data in readonly manner and write some query on tools table or say develop zoom display session on tools table.