How add value in range QueryBuildRange type NoYes

(0) Share

Report

Posted on by maxhammer

Hi

I add value in range QueryBuildRange type NoYes(true or false). See next code.

qbr = qbds.addRange(fieldNum(CustInvoiceTrans, DBOProcessed)); 
qbr.value(SysQuery::value(false));


 
field DBOProcessed type is NoYesId. When i debug my code, value return 255. And my query work not correct. How me correct add value false? Please, help.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

André Arnaud de Cal... 301,482 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Maxhammer,

You can try having the next statements for false:

- 0

- NoYes::No

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

you should write as follows

qbr.value(QueryValue(NoYes::No));

Please verify if this helps you

Was this reply helpful? Yes No
maxhammer on at

Like (0)

Report
Copy link

Link copied!

thank you

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report
Copy link

Link copied!

if you are using SysQuery Class, this is the code

qbr = qbds.addRange(fieldNum(CustInvoiceTrans, DBOProcessed));

qbr.value(SysQuery::value(NoYes::No));

Was this reply helpful? Yes No