Checkbox not working with x++ code

(0) Share

Report

Posted on by Dineshkarlekar

1,817

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

I have the same question (0)

All responses (16)

Answers (6)

Verified answer

Martin Dráb 235,934 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).

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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(); }

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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; }

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,934 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.

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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(); }

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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.

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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; }

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,934 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.

Was this reply helpful? Yes No
Dineshkarlekar 1,817 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.

Was this reply helpful? Yes No