delete inserted row

[HarryDeBoer]

Hi

In an importroutine I import records in a table and at the end I do an updateTable(). I loop through a file and insert a record in the table for each filerow. If a record is not valid I want to delete it (so that it is not imported). Because the record is inserted it has now rownumber so how do I use xxx.deleteRow(?) ? Or is there another way?

Regards, Harry

[Jon]

Harry,

All rows have a row number - it's assigned by the system when the row is inserted.

There are two ways to delete a row, with and without a row number i.e.

Code: Select all

tab.deleteRow();
tab.deleteRow(25);

The first one deletes the table's "current row". A row is the current row when you insert it or when you loop through the rows e.g. you can do this:

Code: Select all

tab.insertRow();
tab.deleteRow();      // deletes the row just inserted

or you can do this:

Code: Select all

var rows = tab.rows;
while (rows.next())
{
  if ...
   tab.deleteRow();
}

To delete using a row number, you would normally find the row first e.g.

Code: Select all

var row = tab.findRow(tab.COL1, "value");
if (row != -1)
  tab.deleteRow(row);

Regards
Jon