Checkbox not working with x++ code

(0) Share

Report

Posted on by Dineshkarlekar

1,479

I have created check box named " show line with scan serial id " in the item arrival forms " line's " overview header section , i my execute query i have written code so if i click my check box the item with serial no scan should appar in grid if i untik check box the grid should be as it is, my code is given below can any one help me out what is wrong with my code.

public void executeQuery()
{
    QueryBuildDataSource   Qbds;

    Qbds = this.query().dataSourceTable(tableNum(WMSJournalTrans));
    Qbds.clearRanges();

    Qbds.addRange(fieldNum(WMSJournalTrans, InventSerialId)).value(queryValue("Scan"));

    super();

}

7750.Checkbox.PNG

All responses (16)

Answers (7)

Verified answer

Martin Dráb 231,777 Most Valuable Professional on at

Like (1)

Report

RE: Checkbox not working with x++ code

Note that your code still contains Qbds variable, which isn't used for anything, therefore it should be deleted. Also note that names of variables should start with lowercase (qbds instead of Qbds).
Dineshkarlekar 1,479 on at

Like (0)

Report
RE: Checkbox not working with x++ code

hi martin , your codes is also working ,I am getting desired output

thanks for help

public void executeQuery() { QueryBuildDataSource Qbds; QueryBuildRange serialIdRange; Qbds = this.query().dataSourceTable(tableNum(WMSJournalTrans)); serialIdRange = SysQuery::findOrCreateRange(this.queryBuildDataSource(), fieldNum(WMSJournalTrans, InventSerialId)); serialIdRange.value(checkbox.checked() ? queryValue("Scan") : SysQuery::valueUnlimited()); super(); }
Dineshkarlekar 1,479 on at

Like (0)

Report
RE: Checkbox not working with x++ code

thanks for help martin , i have used these two method and getting desired output, i will try to do with the code you provided as well.

but do i have to use modified method every time ?

public void executeQuery() { QueryBuildDataSource Qbds; Qbds = this.query().dataSourceTable(tableNum(WMSJournalTrans)); if(checkbox.checked() == NoYes::yes) { Qbds.addRange(fieldNum(WMSJournalTrans, InventSerialId)).value(queryValue("Scan")); } else { qbds.clearRanges(); } super(); }

public boolean modified() { boolean ret; ret = super(); if(ret) { wmsJournalTrans_ds.executeQuery(); } return ret; }
Verified answer

Martin Dráb 231,777 Most Valuable Professional on at

Like (1)

Report

RE: Checkbox not working with x++ code

You're missing an important step in debugging. If you don't get the expected result, look at what query was generated by your code.

Regarding my code, please add () after valueUnlimited, because it should be a method call. I don't have compiler when writing code here in the forum. :) I'll update the code above.
Dineshkarlekar 1,479 on at

Like (0)

Report
RE: Checkbox not working with x++ code

hi martin , i have used the code but getting error . can you plz tell where i am getting wrong.

public void executeQuery() { QueryBuildDataSource Qbds; QueryBuildRange serialIdRange; Qbds = this.query().dataSourceTable(tableNum(WMSJournalTrans)); Qbds.clearRanges(); /* Qbds.addRange(fieldNum(WMSJournalTrans, InventSerialId)).value(queryValue("Scan"));*/ serialIdRange = SysQuery::findOrCreateRange(this.queryBuildDataSource(), fieldNum(WMSJournalTrans, InventSerialId)); serialIdRange.value(checkbox.checked() ? queryValue("Scan") : SysQuery::valueUnlimited); super(); }
Dineshkarlekar 1,479 on at

Like (0)

Report

RE: Checkbox not working with x++ code

hi girish , thanks for reply , If(checkbox.checked()) is also not working , i am not getting deaired output.
Dineshkarlekar 1,479 on at

Like (0)

Report

RE: Checkbox not working with x++ code

hi komi , thanks for reply

i tried your steps but not getting the desired output
Dineshkarlekar 1,479 on at

Like (0)

Report
RE: Checkbox not working with x++ code

hi andre ,thanks for reply

i have two methods but i am not getting desired output can you please explain.

public void executeQuery() { QueryBuildDataSource Qbds; Qbds = this.query().dataSourceTable(tableNum(WMSJournalTrans)); Qbds.clearRanges(); Qbds.addRange(fieldNum(WMSJournalTrans, InventSerialId)).value(queryValue("Scan")); super(); }

public boolean modified() { boolean ret; ret = super(); if(ret) { wmsJournalTrans_ds.executeQuery(); } return ret; }
Verified answer

Martin Dráb 231,777 Most Valuable Professional on at

Like (1)

Report

RE: Checkbox not working with x++ code

Yes, I just modified your code. I didn't meant moving it to another method.
Dineshkarlekar 1,479 on at

Like (0)

Report

RE: Checkbox not working with x++ code

hi martin , thanks for reply , you want me to write this code in my execute query method.