Hi ,
You can use follwoing code
query = new Query();
dsInventTable = query.addDataSource(tableNum(InventTable));
// Add our range
queryBuildRange = dsInventTable.addRange(fieldNum(InventTable, DataAreaId));
queryBuildRange.value(strFmt('((ItemType == %1) || (ItemId == "%2"))',
any2int(ItemType::Service),
queryValue("B-R14")));
Hope it will help you
On 7/3/08, jasuarezh <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I have a problem, I need to create a query with a condition OR, in this
> condition have a comparison with Like.
>
> My query in SQL is:
>
> select * from TABLA1 where TABLA1.campo1 like '%xxxx%' || TABLA1.campo2
> like '%yyyy%'
>
> How I do in Axapta this query???
> Thanks you very much
>
>
>
--
Regards,
Vijay Lad
[Non-text portions of this message have been removed]
