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 Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
