>Hi,
>
>I created an array with a SELECT-SQL statement. I know if the SQL statement does not return any records the array doesn't get created. I have some code I need to process only if the array is created. How can I check for this? Is there a command for arrays similar to SELECT() to determine if the array is occupying a work area?
>
>Thanks,
Check the value of _TALLY. If it's 0, there were no records returned to the array.
Another technique I use is to initialize the array to a know value before the select:
DIMENSION aTest[1]
aTest = "None"
SELECT id FROM table WHERE condition INTO ARRAY aTest
IF aTest[1]="None"
ELSE
ENDIF