My code:
IF RECCOUNT()<>0
COPY TO ARRAY aTemp
SELECT Tickets
APPEND FROM ARRAY aTemp
ENDIF

My error:
Numeric overflow. Data was lost.

The error is generated when the APPEND command is taking place. If the array is already created, why am I getting such error message? Any comments or suggestions to get rid of this error will be appreciated, thank you in advance.