Re: People Code

[Cameron Smyth <csmyth@IDIRECT.COM>]

When you are using peoplecode to manipulate data where there are multiple rows
returned by the panel processor you need to specify which row you are changing.
Try using the function UpdateValue({record.field},Row#,&Value). In the panel
that is oepning up check that any peoplecode that updates the field on any
record present does not do a basic assignment like {RECORD}.{FIELD}= &values.

Good luck,


"Cadenas, Maria (MT)" wrote:

> 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' ?