Re: [Axapta-Knowledge-Village] Company Info table

I think you will have to do something like this: public static void DisplayEachCompany(){ DataArea dataArea; CompanyInfo companyInfo; ; while select dataArea { changeCompany(dataArea.Id) { companyInfo = NULL; select companyInfo; info(strfmt('%1 %2', companyInfo.Name, companyInfo.Address)); }

[Axapta-Knowledge-Village] Company Info table

Hi All, How to get all the data from CompanyInfo Table? If we will write select * from CompanyInfo it will return only Current Company's data not all the rows? Is there any way to fetch all the rows from companyInfo table? Thanks in advance Regards Mohit Rajvanshy

Re: [Axapta-Knowledge-Village] Company Info table

Of course, it just get the current company info because of dataAreaId column. To list all, you can try this: public static void listCompaniesInfo(){ DataArea dataArea; CompanyInfo companyInfo; ; while select dataArea where dataArea.isVirtual == false{ select companyInfo; //do somthing }