Tuesday, 3 March 2015

Container and unbounded string fields are not allowed in a WHERE expression.

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.

No comments:

Post a Comment

intercompany PO multiple product receipt by x++

public void processStampICPO(PackingSlipId _deliveryNote,                             Transdate _deliverydate,                             ...