Deleting and Selecting Multiple Rows in a Datawindow.

[vjgp]

Hi All,

I am using PB 9.0. i have a problem, I want to select rows
(number of rows) and delete them (using a command button)
and also if they dont select the rows, if they hit command
button, it should delete all the rows.
any help will be highly appreciated.

Thanks

VJ

[Jerry Siegel]

When you do the first GetSelectedRow, it won't find any.
I would put up a confirmation message box before deleting all the rows.

<VJ GP> wrote in message news:40e318e4.378...@sybase.com...

[vjgp]

Hi,

I still didn't get what you are telling. Kindly explain with
some code as an example..

Thanks..
VJ GP

[Michael Stoffel]

What would you like help with? Multi-selecting the rows them themselves
(PFC makes this a breeze)? Deleting selected rows (loop through using
GetSelectedRow)?

Mike

<VJ GP> wrote in message news:40e3251a.4db...@sybase.com...

[philipsalgannik]

In your button do smth like:
boolean lb_filter
dw_1.SetRedraw(FALSE)
lb_filter = Long(dw_1.Describe("Evaluate('sum(if
(IsSelected(),1, 0) for all)',1)")) > 0
IF lb_filter THEN
dw_1.SetFilter("IsSelected()")
dw_1.Filter()
END IF
IF dw_1.RowCount() > 0 THEN
dw_1.RowsMove(1, dw_1.RowCount(), Primary!, dw_1, 1,
Delete!)
END IF
IF lb_filter THEN
dw_1.SetFilter("")
dw_1.Filter()
dw_1.Sort()
END IF
dw_1.SetRedraw(TRUE)

[vjgp]

HI All,

Thanks for your sincere effort. It worked fine...

Thanks
VJ

[venkatesh....@gmail.com]

This logic also works-

int ll_row

if dw_all_pws.rowcount( ) > 0 then
ll_row = dw_all_pws.GetSelectedRow(0)
if ll_row > 0 then
dw_all_pws.setfilter( "isselected()")
dw_all_pws.filter( )
dw_all_pws.rowsmove(1, dw_all_pws.rowcount(), primary!,dw_all_pws, 1, delete!)
dw_all_pws.setfilter("")
dw_all_pws.filter( )

end if
end if