Design Question to Remove Rows

[power97]

Hi,
I have a window with 2 tabs on it. All the work gets done on tab 1 and the results are presented on tab 2 ( the logging tab ) . The window doesn't close when they have done some updating because they want to continue working.
I need to remove the rows they have successfully updated from the tab 1 so they don't see them anymore. What would be the best way of accomplishing this ?

p.s. All the updating is using stored procedures.

Thanks

http://www.musicianwanted.ca

 

[tangtang]

rowsdiscard

 

[power97]

Hi,
I have figured it out but I don't know if it's the best way. I created an array and as I look through the rows and update using the stored procedure , if it is successful I ad that row number to the array. Then when I am complete I loop through the array and delete the rows from the datawindow.
The reason why I couldn't just delete from the datawindow on the first pass is then it would mess up what row I'm on . I also could step backwards because I am using RowsModified to go through the rows.
If anyone has any better ideas let me know !

http://www.musicianwanted.ca