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.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!