thanks,
but I need to create it in querybuildrange, not in 'select statement'
rgds,
--- In Axapta-Knowledge-Village@yahoogroups.com, Lalith Jayantha
<[EMAIL PROTECTED]> wrote:
> 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 ;
>
>
>
> 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.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> 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.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - now with 250MB free storage. Learn more.
------------------------ 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/
