Deleting all rows.. 1

[paul102384]

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!..

 

[bernds44]

There are 2 ways to do as far as I know.

1. You can delete all rows which is recomended as you might need the rows later from the deleted buffer. this is when you want to update the deleted rows that they might be deleted in the database too.

DO WHILE dw_1.Rowcount() > 0
   dw_1.DeleteRow(1)
LOOP

2. If you do not need to update/delete the rows in database just performe a simple reset on the datawindow. This will delete all data information

dw_1.Reset()

 

[lealow]

You can also use 'rowsmove' and move all the rows to the delete buffer directly

dw_1.RowsMove(1,dw_1.rowcount(),Primary!,dw_1,1,Delete!)

this will move all rows from the dw_1 Primary buffer to the Delete buffer where the rows will be deleted when you update dw_1.