Exchange data between company

Fiammenghi · 2006-03-16

Hi to all,
I've a native database (Navision 4.00) with 2 company.
Is there a method to read contents of some tables of the other company ?
If so how ?

I know there is a properties of a table (data per company) that if set to no let me share the table, but this is not what I want.

Using code, I'd like to read some records of tables of the other company.

Many tahnks in advance

Fabrizio Fiammenghi

kriki · 2006-03-16

recYourTable.CHANGECOMPANY("The company You Want");
Be carefull NOT to use triggers of the table when putting data in it.
This because if in the triggers another record is read or written, that record will be in CURRENT company!

ara3n · 2006-03-16

Are they going to fix this in Navision 5?

DenSter · 2006-03-16

What do you mean 'fix it'? It works as designed!

ara3n · 2006-03-16

Well it's screwed up design if you ask me.
Ofcourse, your next smart answer would be, "Nobody will ask you. So don't worry"

kine · 2006-03-17

In my opinion it is too complicated to have something like "context" for each record to know in which company you are in context of the original record...

Think about it. If you want to have possibility to call C/AL from another company through some recrod, it means, that all actions called from this record must have own context in which they run (context of the second company). But it is not possible, because part of this context is for example singleinstance codeunit initialized when opening company. But because in this situation you have not opened the company, you have not correct context in which the C/AL code for the second company can run. It is not possible to provide correct context for such a code...

DenSter · 2006-03-17

ara3n wrote:

Well it's screwed up design if you ask me.
Ofcourse, your next smart answer would be, "Nobody will ask you. So don't worry"

No if you'd ask me seriously I would say it's screwed up alright, VALIDATE should work after you change company, a table object's variables should simply inherit the company of the record variable. Man would that ever make my job easier...

The big green smiley face at the end of my comment should clue you in that I was joking.

kine · 2006-03-20

Yes, but inheriting the variables is not enough to have consistent context (think for example about some SingleInstance CU, which is activated on login and you need some values from there to validate some field...).

Exchange data between company

Comments

Categories