Advanced PowerBuilder

Resetting Update Status of All Rows

Say, the last Retrieve() function on a DataWindow returned 1000 rows. Since then, the user changed 200 rows and added couple of them and deleted few of them. Now, he decided to mark all records updated. How will you provide that functionality?

The first thing that might come to your mind is to call Reset() function. However, it doesn't solve the problem. It simply resets the DataWindow, meaning it empties all the DataWindow and displays an empty one to the user. This is not what the user wants!

The other way is, you can reset the status of each row to NotModified! in the DataWindow, delete rows from the Delete buffer using RowsDiscard() function. Sounds easy? Well, it is easy, if there is no other way.

But, there is an easy way to achieve this. You need to just call ResetUpdate() function. That's all. No more coding is required.

Home	Previous Lesson: TAB Key Behavior to the ENTER Key in a DataWindow Next Lesson: Powering up the UP Arrow Key in the DataWindow