Sybase Philippines

hi to all pb programmers:

Can somebody help me on how to delete all rows on a datawindow.

For example there are five rows in dw_1... then delete this five rows in just one execution.

Pls. give a sample code to do this..

thanks!..

Use this Loop

Do While dw_1.Rowcount() > 0
dw_1.DeleteRow(1)
dw_1.Update();
Loop
This wil delete all rows from your datawindow with the help of single execution

Hi! How about moving the rows from the primary buffer to the delete buffer, instead of deleting them one at a time.


dw_1.RowsMove(1, dw_1.RowCount(), Primary!, dw_1, 1, Deleted!)

All the rows in dw_1 will be marked for deletion (i.e. deleted pending update & commit)

Yes we can also use this method that will move all rows from the datawindow Primary buffer to the Delete buffer where the rows will be deleted when you update Datawindow.

If you want to just clear the datawindow with all rows without affecting the records in the database, you can use the Reset() function. dw_1.Reset() will clear/delete the rows from the dw_1 datawindow.