Bob Buford-Abba Systems wrote:
Kathy,
Have you considered putting a key in one of the array fields, then looping through the array to find that key. Once you've determined the element you can do numeric operations (see ARRAY-ADD, ARRAY-DIVIDE, ARRAY-MULTIPLY, and ARRAY-SUBTRACT) and you can do string operations by extracting value, operating on it and "putting" it back into the array.
HTH
Bob-----Original Message-----
From: Kathy Mason [mailto:kmason@GIX-GLOBAL.COM]
Sent: Friday, November 05, 1999 12:32 PM
To: Multiple recipients of list SQR-USERS
Subject: Updating an arrayDatabase Oracle 7
SQR Version 4
Platform HPUXI was wondering if there is a simple way to update an array.
I am working on an SQR that prints data as it is selected but writes to a file
when the id changes. I am storing dependent data in an array because one ee may
have numerous dependents.
I get their medical info and insert into an array - I need to then update array
after I get the dental info. Is that possible? I couldn't file anything
referencing this in the archives or in reference books. Perhaps I am looking
for the wrong thing.Any help would be appreciated.
Kathy