The following example creates an array from selected records in the customer
table and then uses ACOPY( ) to create a new array.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')
USE customer && Open customer table
SELECT DISTINCT company ;
FROM customer ;
ORDER BY company ;
WHERE country = 'Germany';
INTO ARRAY gaCompanies
= ACOPY(gaCompanies, gaCompaniesTemp) && Make a copy of the array
CLEAR
DISPLAY MEMORY LIKE gaCompaniesTemp