Loop through form data source with paramter

(0) Share

Report

Posted on by brianmaric

Hi I'm updating fields on a form data source that only meet a certain criteria:

        TestTmpLocal = TestTmp_ds.getFirst() as TestTmp;

        TestTmpLocal.selectForUpdate(true);
                
        while (TestTmpLocal)
        {
            if(TestTmpLocal.InventTransId == _inventTransid && TestTmpLocal.InventDimId == _inventDimId )
            { 
                TestTmpLocal.RemainQty = TotalRemainQty;

                ttsbegin;
                TestTmpLocal.doUpdate();
                ttscommit;
            }

            TestTmpLocal = TestTmp_ds.getNext() as TestTmp;
        }

But this way I'm looping through all the records.

Is there a way to query the dataset just where inventtransid and inventdimid match?

All responses (3)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, If it's TempDB table, can you try update_recordset. I don't remember if there is any limitation for temp db tables but if it works, you can avoid looping all records in table
brianmaric on at

Like (0)

Report
Copy link

Link copied!

It works except it's making the quantity that I enter disappear
brianmaric on at

Like (1)

Report
Copy link

Link copied!

just needed to update the record first..