Using Find on Array of Record in PeopleCode
I've created an Array of Record, populated it with data from a table... later I need to do a find on it to get a record that I want. The find isn't finding data that I know is in there. I must be doing something wrong, but I can't locate an example of the find command used on an Array of Record.
Local array of Record &MY_array;
Local Record &MY_work_rec;
&MY_work_rec = CreateRecord(Record.MY_TEMP_TAO);
&SQL_MY = CreateSQL(Select ... );
While &SQL_MY.Fetch(&MY_work_rec)
&MY_array.Push(&MY_work_rec);
&MY_work_rec = CreateRecord(Record.MY_TEMP_TAO);