Use SQL-SELECT instead:

select field1 from tableList where not empty(field1) into array aTables
? _tally  && shows how many were selected

>this code is getting all the records of tablelist first column and filling it in the array.
>I want to put a condition not to get the empty records.
>

> ************************
>SELECT TableList
>nRecCount = IIF(RECCOUNT()<= 0,1,reccount())
>DIMENSION aTables(nRecCount,1)
>COPY TO ARRAY aTables
> *************************