[sqr-users] help

["Robin Ferebee" <Robin_Ferebee@nexnet.navy.mil>]

Good morning.  I am attempting to delete a row on a level 1 scroll.  I
begin by referencing my level 0 scroll and traversing down.  When I
identify the row, I call the DeleteRow function. All the data is removed
except for the two date fields which are on two different tabs.  When I
query the database all the data is removed except for the emplid and the
dates.  I have customized the Purge Date field to clear all fields for that
row when a Purge Date is entered.

[Administer Workforce ==>Manage Labor Relations(GBL) ==>Use ==>Disciplinary
Action ]

I am including some of the code I created to try and delete the row
automatically.

     For &J = 1 To &LINE_ROWSET.RowCount
         &LINE_REC = &LINE_ROWSET(&J).DISCIPLIN_ACTN;
         &LINE_SUM = &LINE_REC.DISCIPLINARY_TYPE.Value;
         If &LINE_SUM = " " Then
            DeleteRow(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J);
            &G_CLEAR = "N";
            If RecordDeleted(Record.DISCIPLIN_ACTN, 1,
Record.DISCIPLIN_STEP, &J) Then
               WinMessage(MsgGet(20000, 203, "A row has been deleted."));
            End-If;
         End-If;
      End-For;


Thanks.


Robin S. Ferebee
PeopleSoft Group
Navy Exchange Service Command
(757) 631-3347




***************************defiant************************************
This email and any files transmitted with it are intended solely for 
the use of the individual or agency to whom they are addressed. If 
you have received this email in error please notify the Navy Exchange
Service Command e-mail administrator.

This footnote also confirms that this email message has been scanned 
for the presence of computer viruses.

messaging_support_team@nexnet.navy.mil
**********************************************************************

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users