>I have a method to look for tables saved buy certain users and create a SQL array.
>
>LOCAL ARRAY aHold(1)
>SELECT * ;
>FROM &tcTable ;
>INTO ARRAY aHold ;
>WHERE !lUploaded AND cUserName = cCurUser

select * ;
from (tcTable) ;
into cursor curResult ;
where ...

1) You can use name expression instead of macro, though it doesn't matter.

2) How many fields and records this SQL produces?
Number of records x Number of fields should be less than 65000 - maximum number of elements in array.



>
>This works in the dev envir but not in the exe. Got any ideas?
>
>Thanks for the help