Re: People Code

[Rick_Creel@AONCONS.COM]

I can only address question #1:

It would depend on how the keys are declared in App. Designer.  Typically the
keys, including EFFDT, are delcared as ASCENDING.  If this is the case, and
assuming you have more than one effective dated row, your query will NOT get the
max date.  The only way to guarantee getting the max date is to have it as part
of your 'WHERE' condition.  I know this is a royal pain, but better safe than
sorry :-)






"Cadenas, Maria (MT)" <MCadenas@DOW.COM> on 09/26/2000 03:28:20 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  People Code



Okay guys, I know this is not an SQR question, but if anyone knows
PeopleCode, please help:

Here are my lovely questions:

1) In People code, when you select  from a table and there is a 'Effective
Date ' as field.  Will the query automatically pick the max effective date?

2)I have a panel then updates a field when the panel opens up. That is Ok
but what it also does is change the data for that field in all the history
panels. This results in incorrect data in all the history fields. How do you
prevent a field from changing in the history records if the  Peoplecode
indicates to update the field when loading the panel? Is there a way
preventing this other than taking the code out of the 'Rowinit' ?