Hi anton
Create a string type Extenderd data type and asign the string value to Extenderd data type
ex: if Extenderd data type is "Likestring"
assign the string value
Likestring = '%RV%'
select accountnum, voucher, * from ledgerjournaltrans where voucher
like Likestring ;
like Likestring ;
Lalith
anton_tjiptadi <[EMAIL PROTECTED]> wrote:
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
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
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 the Yahoo! Terms of Service.