juvenile
19th July 2004, 06:25
Hai Baan gurus,
I am very new to Baan Platform.I hope my questions are very silly to u
but these answers are helpful to me.
Pls correct if am wrong.

1) Every VRC have its own objects and source code right??(BSE/application)

2) And also Every VRC has its own DataDictionary?(BSE/dict)

I hope the above both statments are correct.

My doubt is Does Every VRC has its own DB tables??
If not why Baan is maintaining BSE/dict seperately for every VRC??

And suppose in VRC1 in table1 having 5 fields,and in VRC2(is derived from VRC1) can I add or delete some fields??
If so How baan manages??

rgds,
Juvenile

günther
19th July 2004, 08:40
As you are new to baan, I remember my first confusion about that ... But after a while you will find it quite simple.

So here are my results:
1.a) Every PVRC has its own objects - YES.

1.b) Every PVRC has its own source code - YES and NO. For regular scripts (session scripts, report scripts, library sources) I would say yes. But for #includes the derivation will automatically find the correct file to be included (so that it is not necessary to copy the whole structure).

2. Eyery PVRC has its own DD -- NO. Every PACKAGE COMBINATION has its own DD. For each packages (tc, td, ti) it is possible to have different PVRCs; you only have to decide which of them are used in a specific packagees combination. (But that is more for admins than for developpers.)

3. Database tables are used according to the package combination (and or DD).

Here is an example: You have a new package xx and module yyy; you have a test vrc (b40c/c4/test) and a live vrc (b40c/c4/live); and you have two package combinations "B4Cc4tes" (that uses xx from vrc b40c/c4/test) and "B4Cc4liv" (that uses xx from vrc b40c/c4/live).
Finally, you have a table xxyyy001 that has fields aaaa and bbbb. In your test vrc you can now add a field cccc, (and convert to runtime) and test it. After all works as expected, you can export/import the dd for table xxyyy001 from your test vrc to your live vrc.

Remember: It's easier than it sounds!

Günther

jack786
19th July 2004, 10:16
Thanks alot for ur answers,pls clarify one doubt.
we are using SQLServer with baan4.
for a areas table in baan tcmcs045(company 400).for the same in SQL Server ttcmcs045400.

Does one company can be linked to more than one package combination?
If it so give me the answer for the 1st Question.

1) assume that we have 3 package combinations exist in the system.
Can we find 3 tables of ttcmcs045400. So what are those table names How can we find?

or else Every package combination is linked to one separate company,so those three tables are like ttcmcs045(XXX),ttcmcs045(YYY),ttcmcs045(ZZZ)?


rgds,
Jack

günther
19th July 2004, 10:31
You have some companies; in ttaad100m000 "Maintain Companies" you see their package combination, and so you can find out their PVRC.

You normally have tables per company. So a table tcmcs045400 (maybe with an additional t, but that is only the database point of view outside of baan) is the table tcmcs045 from comany 400.

Günther

jack786
19th July 2004, 12:47
Only 1-1 relation is maintained between companies and package combinations right??

günther
19th July 2004, 12:49
Only 1-1 relation is maintained between companies and package combinations right??
Yip, that's right.

jack786
19th July 2004, 12:55
So Every package combination has its own set of tables in Database right??
I hope u will answer to my Question :-)

günther
19th July 2004, 12:59
So Every package combination has its own set of tables in Database right??
I hope u will answer to my Question :-)
I would say yes.

KhRamil
19th July 2004, 13:24
Hi!
Originally Posted by jack786
Only 1-1 relation is maintained between companies and package combinations right??

In a PC (package combination) can be more than one company: 0,1,2,3...
Regards,
Ramil