Re: [sqr-users] help

["Larry Roux" <lroux@syr.edu>]

The SQR Users group is probably not the best place for this as not all SQR 
users are PeopleSoft users.

However, you might want to check the field defaults and PeopleCode to see if 
those fields have default values that are repopulating the data.  




******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> Robin_Ferebee@nexnet.navy.mil 04/07/03 07:52 AM >>>
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


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