Hi Suhas,

Using _TALLY is very clear...

Another testes:
1) Using TYPE()

SELECT field FROM table WHERE field="nothing" INTO ARRAY laPom
?TYPE("xxa")
* U if SELECT return 0 rows
* non U if SELECT return 1 or more rows

2) Test of default size array if you want return 2 or more columns

LOCAL ARRAY laPom(1)
SELECT field,field2 FROM table WHERE field="nothing" INTO ARRAY laPom
?ALEN(laPom)
* 1 if SELECT return 0 rows
* >1 if SELECT return 1 or more rows

MartinJ

>hi,
>I am facing a problem
>
>Select into array ...
>
>how do i know that the arrry is created other than the use of _tally ?
>
>TIA
>suhashegde