Roi,
_Tally system variable contains # of records retrieved from prior Select so just:
IF _Tally > 0 && Make sure selected something
PF
>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.
(On an infant's shirt): Already smarter than Bush