Advanced PowerBuilder

Removing Unwanted Rows

For any reason if you want to get rid of some rows in a DataWindow (but not from the database), what you do?

You might have thought of calling DeleteRow() function. Well, you can do that, however, the DeleteRow() function moves those rows into Delete buffer, meaning, they will also get deleted from the database when you call Update() next time on that DataWindow.

The other option is to create a DataStore and assign the same DataWindow object and use RowsMove() function to move rows from the DataWindow to the DataStore. In case if the user wants to restore it back, you don't have to retrieve them from the database all over again; you can move them back to the DataWindow. Please note that, when you move rows using RowsMove() function, the row status in the target DataWindow is set to NewModified! And you may want write some code to store the row and column statuses.

If you do not want to restore functionality, you can just call RowsDiscard() function which removes these rows from the DataWindow, but do not populate Delete buffer.

Home	Previous Lesson: Other Non-Mapped, but Important DataWindow Events Next Lesson: Data Retrieval Cancellation