Running a report of company B connected to comp. A same db

andy76

Hello everyone,

I have a database having 2 companies inside.
I ask you if it is possible, being connected to company A with client, to run a report processing data on company B without changing company.

Thank you

ssingla

Search the forum for "ChangeCompany" function which can help you to pull data from any company in the database.

andy76

Yes, I found some post.
My report is used to import/modify data in Customer Table reading it from a text file.
I read that CHANGECOMPANY function is not good for everything, for example, VALIDATE functions are run on the company where I am connected and so on....

Is it possibile to use CHANGECOMPANY function in code executed by NASSQL?

Thank you

FDickschat

If you need to validate fields forget about the changecompany solution.

Best is probably to import the file 1:1 into a staging table. Setup that table either as data per company = No, with a field Company Name or as data per company = yes and store the imported data with changecompany in the correct company (but don't process).

Then setup one NAS per company which will take care of the processing of the imported data. You could of course use only one NAS for the foreign company and process the imported data in the current company right away.