Tools Tables which can be created for a company different than 000

[i96nds]

Hi,

I wonder if anybody can help me with this:
I am trying to write a script which generates the name of the tables that are Valid for a certain Package Combination. This would be useful for me to get a file that contains the list of the tables - for bdbpre6.1. In this script I have added an option if I want to include the logical tables, etc.

The ideea is quite nice and useful. The script works fine. I get the list of the tables. There is a problem regarding TOOLS tables. If I use session "Create seq dump of table" - ttaad4226m000, only the following tables are dumped, if I dump a company <> 000.

ttaad500
ttaad501
ttaad503
ttaad505
ttaad506
ttaad507
ttaad510
ttaad511
ttaad512
tttxt001
tttxt002
tttxt003
tttxt004
tttxt005
tttxt006
tttxt007
tttxt008
tttxt010
tttxt012
tttxt016
tttxt030

If we dump company 000, all TOOLS tables are dumped. So, only few "tt" tables can be created in a company <> 000. Do you have any idea how does Baan know the list of this tables? I did not find anything useful in table ttadv420.... There must be a field YES/NO which tells that a table, for example tttxt020 or ttdsk* can be created only in company 000.

Does anybody have any idea?

[alejandro]

There is a function that returns you if a table is present in a certain company.(BaaN IV c4)

If I understood you well, this I propose is an indirect method but, maybe...

#pragma used dll ottadvtablecomp

long yeno
yeno=table.in.compnr(string table(8),long cmp )

Hope this help...

[i96nds]

Thanks, this solves only a part of the problem. What I really need to do is to generate a list of tables for a specific package combination. This is necessary because we have several companies, in a multi-company scenario. So, I need to make a dump of all these companies at the same time. If I dump 4 companies that reside on the same package combination, I should use only one list of tables, and not four, depending on the output of table.in.compnr(...). I will keep hins functon in mind, though. Thanks.

I managed to find this function in ttstpsearchvrc:

function extern long vrc_search_table
(domain ttadv.cpac cpac,
domain ttadv.cmod cmod,
domain ttadv.flno flno,
long tdep
ref domain ttadv.vers tver,
ref domain ttadv.rele trel,
ref domain ttadv.cust tcus,
)

I thought I may use this function, since this is what I need to get the right list of tables. But I do not understand what the parameter tdep does... Any clue?

Anyway, I still have the question about how does this function know that some Tools tables should not exist in any company diferent than 000....

Any idea?
Thanks,

[alejandro]

Well,

Session ttaad4222m000 makes a report counting rows in a table.
If you entry:

- Company: The first company number in a package combination
- Package : From tt
To tt
- Table : From [empty]
To zzz999

Then in the report you have the list of tables defined in that package combination, for that package.

You can put the output to a file and read it.
Notice that the first table is always in the same row of the file, and you have to read after line read (without trailing spaces begin with Total)

You can define a Job.
As you can see this tables are in the standard package tt, and tt do not belong to any package combination than standard (ttaad1121m000) So tools tables are those you listed in any package combination. ( I guess you forgot in that list table ttaad502).

I have no other idea hopefull for you.
Hope this helps.

[NPRao]

Hi Stephen,

I guess you are referring to this dll -

ttdllvrcsearch

I could not find the

ttstpsearchvrc

[i96nds]

I tested so many things that I was dizzy. I have written the wrong dll, you are right.

It should have been: ttdllvrcsearch

$ >bic_info6.1 -e ottdllvrcsearch

---------------------------DLL PROTOTYPES-------------------------------

............................. - many others - .....................

function extern long vrc_search_table(
domain ttadv.cpac cpac,
domain ttadv.cmod cmod,
domain ttadv.flno flno,
long tdep,
ref domain ttadv.vers tver() fixed,
ref domain ttadv.rele trel() fixed,
ref domain ttadv.cust tcus() fixed )

[NPRao]

Sure thats ok... you seem to be working late in Romania...

did you try to use the session to get the documentation

ttstpbaandoc (in HTML form)

ttstpobjinfo (show object info - gives output on the display browser) instead of using the command line options...

[i96nds]

Hi,

I think it is daylight in USA, right? In fact, I work in Italy now, for a while, as you can see from the e-mail address. Here I have one extra hour, comparing with Bucharest.

A real Baan "addict" can not sleep until he finds out the answer to his questions... I am at home, connected to the IBM Shared Network, in fact...

I did not understand what you ment with:
ttstpbaandoc (in HTML form). How can I get this? Please guide me, if possible.

The baan session I think it is ttstpsessinfo. It gives quite the same output, right? Or... can I get extra information if I use the Baan session?

Ciao,

[NPRao]

Yes its day light here.

the session ttstpbaandoc - is "Generate Library Documentation" you can get the library function prototypes etc in a HTML pages, can be viewed with Internet Explorer. If you cant find it in the tools menus, use the start, run option to check up if its delivered to you or not.

I dont know which BaaN version are you working on. But this is available in the New ERP series.

the session, ttstpobjinfo (show object info - gives output on the display browser) instead of using the command line options...
$ >bic_info6.1 -e ottdllvrcsearch
I feel that all the command line options of the bic_info are built into tihs sesion, ttstpobjinfo.

I hope this helps you out.

Good Luck!

[i96nds]

Unfortunately I do not have any Baan ERP accesible here....
I work on Baan IV c4. Now I do understand why I could not find the sessions

ttstpobjinfo
ttstpbaandoc

Thank you anyway. I hope that one day I will be able to understand all secrets of the tools sessions, which seem very interesting to me, because of the skills a programmer should have to write such sessions. I will keep learning... But the documentation that Baan offers is quite poor, I may say.

Regards,

[i96nds]

I noticed something strange in what "alejandro" said. He told me that I have forgotten table ttaad502. I had taken a look in my system few days ago and I did NOT have this table. I knew some tables were delivered by baan at a certain moment. I managed to find on Baan support the solution 104950:

After this action you should create 3 new tables for company 000. The easiest way is to start general table maintanance and select this table. On the question "File does not exist, allocate" you should answer "Yes" and the table will be created. Do this action for the tables ttaad321 ttaad502 and ttaad330. Table ttaad502 should be created for all companies.

I found out that there are some other tools tables delivered wi SP9 for BaanIVc4: ttaad322, ttaad331, ttaad508.

I did some new researches and.... I have table ttaad502 now. Surprise!!! Patches were installed last night !

Anyway, be careful with the patches.

The strange thing that I noticed is that I was able to allocate the table ttadv200 (Sessions !!!) in company 110, using General Table Maintainance , which seems quite strange to me.

All Tools tables, except the ones written above in previous posts + ttaad502, can NEVER be created using the session "Create tables", but can be created using GTM.

The session "Create tables" is smart enough not to create tables ttaad321, ttaad330 in company 110. It only creates table ttaad502, as described in the solution I quoted here.

Here I come again:
How does session "Create tables" know to do this? Why GTM and "Create tables" do not use the same algorithm / function for checking the validity of a table for a certain company (diferent than 000) ? It seems that they are not both using "ttdllvrcsearch"...

I am quite confused, now. The table ttadv200 can NOT be deleted using session "Delete tables". So, I think this is a bug, since this table can be created using GTM but can never be deleted. What do you think?

Regards,

[alejandro]

Your explanation seems to be very clear. It is inconsistent. I think you should report this like a BaaN to support.

Be luck. Sorry, because I have no other thikg to suggest you.