Oracle JDeveloper 11gR2 Cookbook

Removing a row from a rowset without deleting it from the database

There are times when you want to remove a row from the view object's query collection (the query result set) without actually removing it from the database. The query collection, oracle.jbo.server.QueryCollection, gets populated each time the view object is executed—when the view object's associated query is run—and represents the query result. While the Row.remove() method will remove a row from the query collection, it will also remove the underlying entity object for an entity-based view object, and post a deletion to the database. If your programming task requires the row to be removed from the query collection itself, that is, removing a table row in the UI without ...