A Database Resource can also be configured for use with multiple rows. A table can be backed by such a Database Resource by setting the table's Resource property.
To configure a Database Resource in this way, the For use with Table operations (multiple rows) option should be checked.
The following operations are available via the tables interface:
- Load a resource and populate a mapped table:
tables.myTable.fetchTable()
- Update the database to reflect any changes made to rows in a mapped table:
tables.myTable.updateTable()
- Insert a new row into the table:
tables.myTable.insertRow()
- Delete the current row from the table:
tables.myTable.deleteRow()
When performing insert or delete operations the changes are not made on the database until the updateTable() function is called.
The delete operation will remove the current row from the table. You may have to loop through the rows of the table to find a specific row to delete.