srinib
asked on
Delete selected rows
Hi,
I want to delete selected rows from my dw.
I had written the below code for this.
Long ll_Rows,ll_i
ll_Rows = dw_1.RowCount()
FOR ll_i = 1 To ll_Rows
IF dw_1.IsSelected(ll_i) THEN
dw_1.DeleteRow(ll_i)
END IF
NEXT
It is not deleting all the selected rows. I think, row numbers are changing after first delete.
What is the another way?
Thanks
Srinib
I want to delete selected rows from my dw.
I had written the below code for this.
Long ll_Rows,ll_i
ll_Rows = dw_1.RowCount()
FOR ll_i = 1 To ll_Rows
IF dw_1.IsSelected(ll_i) THEN
dw_1.DeleteRow(ll_i)
END IF
NEXT
It is not deleting all the selected rows. I think, row numbers are changing after first delete.
What is the another way?
Thanks
Srinib
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Long ll_Rows,ll_i
ll_Rows = dw_1.RowCount()
FOR ll_i = 1 to ll_rows
IF dw_1.IsSelected(ll_i) THEN
dw_1.DeleteRow(ll_i)
ll_i=1
ll_Rows = dw_1.RowCount()
END IF
NEXT
goodluck
gajender
ll_Rows = dw_1.RowCount()
FOR ll_i = 1 to ll_rows
IF dw_1.IsSelected(ll_i) THEN
dw_1.DeleteRow(ll_i)
ll_i=1
ll_Rows = dw_1.RowCount()
END IF
NEXT
goodluck
gajender
try,
Long ll_Rows,ll_i
//ll_Rows = dw_1.RowCount()
FOR ll_i = 1 to dw_1.RowCount()
IF dw_1.IsSelected(ll_i) THEN
dw_1.DeleteRow(ll_i)
END IF
NEXT
Cheers,
Rosh