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 |
|---|---|---|
| Inserting records | PeopleSoft Technical | 07/28/2010 - 11:03am |
| WEBLIB_PT_NAV.ISCRIPT1.FieldFormula.IScript_PT_NAV_PAGELET error... | PeopleSoft Technical | 07/27/2010 - 2:02pm |
| Basic language | PeopleSoft Technical | 07/27/2010 - 7:12am |
| Rowlevel security from app designer | PeopleSoft Technical | 07/27/2010 - 5:15am |
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)
Post new comment