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?
