I want to create query range with "like" and "or" criteria",
something like this :
(SQL Statement)
select accountnum, voucher, * from ledgerjournaltrans where voucher
like '%CPP%' or voucher like '%RV%'
My statement rises an error if I wrote it like this one in X++ :
sCrit = strFmt('((Voucher like %1) || (Voucher like %2))',
"*CPP*", "*RV*");
qRange2 = qbds1.addRange(fieldnum(LedgerJournalTrans, Voucher));
qRange2.value(sCrit);
please help,
thanks in advance,
Anton
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.