Some time when we give a str variable in where condition it gives an error.
str Account;
;
select firstOnly bankAccountTable
join RecId from ledgerDimension
where ledgerDimension.DisplayValue == bankAccountTable.AccountID
//if(bankAccountTable.AccountID == any2str(Account))
&& bankAccountTable.AccountID == Account;
error message :Container and unbounded string fields are not allowed in a WHERE expression.
Str 50 Account1,Offset_account1;
select firstOnly bankAccountTable
join RecId from ledgerDimension
where ledgerDimension.DisplayValue == bankAccountTable.AccountID
//if(bankAccountTable.AccountID == any2str(Account))
&& bankAccountTable.AccountID == Account1;
error gone and it will work perfectly.
str Account;
;
select firstOnly bankAccountTable
join RecId from ledgerDimension
where ledgerDimension.DisplayValue == bankAccountTable.AccountID
//if(bankAccountTable.AccountID == any2str(Account))
&& bankAccountTable.AccountID == Account;
error message :Container and unbounded string fields are not allowed in a WHERE expression.
Str 50 Account1,Offset_account1;
select firstOnly bankAccountTable
join RecId from ledgerDimension
where ledgerDimension.DisplayValue == bankAccountTable.AccountID
//if(bankAccountTable.AccountID == any2str(Account))
&& bankAccountTable.AccountID == Account1;
error gone and it will work perfectly.
No comments:
Post a Comment