I have the following SQL select in a custom method (thisform.RefreshArray) on a form.

SELECT CatName ;
from CatDisplay ;
where CatUsed = .T. ;
into array laSelCats

This array already exists (scoped as public), is replaced by the above, and then passed by reference from another method as a parameter to a custom method in class.

ie. a click event for a button would be:
thisform.RefreshArray
thisform.Myclass.Redisplay(@laSelCats)

My problem is occasionally the select will not select anything, which is ok, however, since the array already exists it will contian the previous incorrect values.

I tried adding a release laSelCats before the select but that screws up the reference.

Anybody have any ideas about how to get around this?

Thanks in advance.