>>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
>>
>>This works in the dev envir but not in the exe. Got any ideas?
>>
>>Thanks for the help
>
>Try dimensioning the array before the SQL Select statement. Size doesn't matter.

...and you may start believing it if enough women tell you...

It is important to dimension the array as a two-dimensional construct if you want to have local scoping - it's the two dimensional aspect rather than the size of the dimension. Trying:

LOCAL aHold[1,1]

might help. Of course, if the number of elements created by the query exceeds 65,000, VFP will give you the lovely 'Too many variables' error (# elements = #rows x #columns, but you knew that...)

See, it's possible to be too big...