>Check the Type() value of the item in laSelCats[1,1]. If it's "U" the array is empty. _Tally doesn't work correctly on arrays I've found.
>
Barbara, since the array exists already in his example and is scoped as PUBLIC, I think he'd be better off doing something like:
DIMENSION laSelCats[1,1]
laSelCats = NULL
before the Select, and then check ISNULL(laSelCats[1,1]) afterwards to see if anything happened.
>Barbara
>
>>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.