Query extended range failure: Right parenthesis expected near pos 19.

Finance and Operations/AX Developer Forum
1

Hi Everyone,

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

Below is my code.

queryBuiltRange.value(strFmt(’(%1=="%2")’,fieldStr(Table5,StringValue),queryValue(GetValue.valueStr())));

Please anyone sugges me.

2

Can you please show us what you’re passing to queryBuiltRange.value(), i.e. what you get from strFmt()? We don’t know what you have in GetValue control.

Also, is queryBuiltRange a range for Table5?

3

Hi,

queryBuiltRange.value(strFmt(’(%1=="%2")’,fieldStr(Table5,StringValue),queryValue(“Item”)));

Table5 in QueryBuildRange below is the code,

queryBuiltRange =queryBuildDataSource.addRange(fieldNum(Table5,ItemType));

4

But why you do such a thing at all? As you see, the extended query syntax is ugly and error-prone; you shouldn’t use it unless necessary. And it’s not necessary in your case; you can simply use this:

stringValueRange = queryBuildDataSource.addRange(fieldNum(Table5, StringValue));
stringValueRange.value(queryValue(GetValue.text()));

Isn’t it much easier?