>>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.
Thanks a lot, ADEL was critical.
If it's not broken, fix it until it is.
My Blog