In while Statement
static void JobDemoCrossCompany(Args _args)
{
BankAccountTable tabBAT; // saveDataPerCompany == true.
container conCompanies = [ 'cm1', 'cm2', 'dat' ];
str 4 sCompanyPrevious = " "; // Maximum length is 4 characters.
int iCountCompanies = 0;
;
while select
crossCompany
: conCompanies
* from tabBAT
order by dataAreaId
{
if ( sCompanyPrevious != tabBAT.dataAreaId )
{
info( tabBAT.dataAreaId + " = tabBAT.dataAreaId" );
iCountCompanies++;
if ( iCountCompanies >= 2 )
{
break;
}
sCompanyPrevious = tabBAT.dataAreaId;
}
}
return;
}
with QueryNode
static void JobDemoAllowCrossCompany(Args _args){
BankAccountTable tabBAT; // saveDataPerCompany == true.
Query qry2;
QueryBuildDataSource qbds3;
QueryRun qrun4;
str sCompanyPrevious = " ";
int iCountCompanies = 0;
int iTableNumBAT;
;
qry2 = new Query();
qry2.allowCrossCompany( true );
qry2.addCompanyRange( 'dat' );
qry2.addCompanyRange( 'twf' );
iTableNumBAT = tableNum( BankAccountTable );
qbds3 = qry2 .addDataSource( iTableNumBAT );
//qbds3.company( 'dat' );
qrun4 = new QueryRun( qry2 );
while ( qrun4.next() )
{
if ( qrun4.changed( iTableNumBAT ) )
{
tabBAT = qrun4.get( iTableNumBAT );
if ( sCompanyPrevious != tabBAT.dataAreaId )
{
print( tabBAT.dataAreaId + " = tabBAT.dataAreaId" );
iCountCompanies++;
if ( iCountCompanies >= 2 )
{
break;
}
sCompanyPrevious = tabBAT.dataAreaId;
}
}
}
pause;
return;
}
No comments:
Post a Comment