>Hi everybody,
>
>I have a code like
>
>select field from sometable where ... into array thisform.myArray
>
>If there is no records satisfying the condition, the form's array doesn't change.
>
>The question is - how can I reset the array?
>
>Thanks in advance.
You want to set the array back to 1?
Something like
dimension thisform.myArray[1]
=ADEL(thisform.myArray, 1)
select field from sometable where ... into array thisform.myArray
Then you could check _Tally if the select statement return something.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers