A table or cursor is created always regardless if query returns any result. You can use _TALLY system variable to check how many records returned by query.
SELECT * FROM mytable ;
INTO ARRAY myArra
IF _TALLY > 0
ENDIF
>Hi,
>
>How can I determine if the array or table has been created successfully?
>When I use the Select-SQL to create a table or an Array, how do I find out if they exist?
>
>Thanks.
>
>Ria
--sb--