Query extended range failure: Right parenthesis expected near pos 0. this error is appearing.

(0) Share

Report

Posted on by Community Member

hello masters,

i have created a query (below) and when i run it .it gets this error(Query extended range failure: Right parenthesis expected near pos 0. )

q = new Query();
qbds = q.addDataSource(tableNum(InventItemGroupItem));
qbds.name('ItemGroupMaster');
qbds.addRange(fieldNum(InventItemGroupItem, ItemId)).value(strFmt('((%1.%2 == "DAPJCON0001") || (%1.%3 == IG08))',
qbds.name(), fieldStr(InventItemGroupItem, ItemId),
fieldStr(InventItemGroupItem, ItemGroupId)));

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (2)

Report
Hi Kavaljeet Singh,

Try this

qbds.addRange(fieldNum(InventItemGroupItem, ItemId)).value(strFmt('((%1.%2 == "DAPJCON0001") || (%1.%3 == "IG08"))',
qbds.name(),
fieldStr(InventItemGroupItem, ItemId),
fieldStr(InventItemGroupItem, ItemGroupId)));

So you forgot to put "" around IG08

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (2)

Report

Crispin, the extra parentheses are necessary for the extended query range syntax. In your case, AX would simply look for ItemId with the given value ("InventItemGroupItem.ItemId == ..."), it wouldn't interpret it as SQL.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@ievgen Thanks you got it write, you spotted the mistake.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

@Martin thanks for the reply.

Can u suggest more about Extended query range

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

There is a good article explaining how to use them www.axaptapedia.com/Expressions_in_query_ranges

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this is the same article Martin has suggested

Was this reply helpful? Yes No