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?
just needed to update the record first..
It works except it's making the quantity that I enter disappear
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
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156