A very simple yet very useful code to give users the option to delete all grid rows on a page at once. I've implemented such a requirement by placing a "Delete all" button above a grid to give PeopleSoft users the option to delete all rows at once instead of clicking the "-" grid button. If the gird has, lets say, 20 rows, then a user will have to click the "-" delete grid button 20 times to delete all rows, compared to one click on the "Delete all" button.
Place the code below behind a field change event.
It is important to point out that users will still have to save the page for the deletion to take place at the database level.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Comments
Another form -Visual-:
Local Rowset &MiRowSet = GetRowset(Scroll.MyScroll);
&MiRowSet.Flush();
The records will be deleted from the buffer not from the DB.... if you want to delete from DB in the same buttom:
Local SQL &MySQL;
&MySQl = CreateSQL("Delete from %Table(:1) where KEY1 = :1 And ...",Record.MyTable,&MyKeys)