omit via loop

[John]

Johan,

I added a sample solution that demonstrates the problem to case id 215729.
The same code is below if anybody else wants to test it. Here are results I got.
before omit: 3 2 1
after omit: 1 2

Thank you.

John

Code: Select all

function onShow()
{
   foundset.deleteAllRecords();
   for (var i = 1; i <= 3; i++)
   {
      foundset.newRecord();
      foundset.sample_text = 'a';
   }
   // Sort on non-unique column.
   foundset.sort('sample_text asc');
   
   // Output order.
   var order = 'before omit:';
   for (var i = 1; i <= foundset.getSize(); i++)
   {
      order += ' ' + foundset.getRecord(i).sample_table_id;
   }
   application.output(order);
   
   // Call omitRecord().
   foundset.omitRecord(1);
   
   // Output order.
   var order = 'after omit:';
   for (var i = 1; i <= foundset.getSize(); i++)
   {
      order += ' ' + foundset.getRecord(i).sample_table_id;
   }
   application.output(order)
}