I think you will have to do something like this:
public static void DisplayEachCompany()
{
DataArea dataArea;
CompanyInfo companyInfo;
;
{
DataArea dataArea;
CompanyInfo companyInfo;
;
while select dataArea
{
changeCompany(dataArea.Id)
{
companyInfo = NULL;
select companyInfo;
info(strfmt('%1 %2', companyInfo.Name, companyInfo.Address));
}
}
}
{
changeCompany(dataArea.Id)
{
companyInfo = NULL;
select companyInfo;
info(strfmt('%1 %2', companyInfo.Name, companyInfo.Address));
}
}
}
kbi kbi <[EMAIL PROTECTED]> wrote:
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}}BRKhue
mohit rajvanshy <[EMAIL PROTECTED]> wrote: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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Varden Morris
Senior Developer
WellPoint Systems Inc.
(403) 444-5848 direct
(403) 444-3900 main
www.wellpoint.ca
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
SPONSORED LINKS
Business finance course | Business to business finance | Small business finance |
Business finance consultant | Business finance magazine | Business finance uk |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.