>>I have a method that is called during the refresh method of a control that has this line in it:
>>
>> IF SEEK(.ctrZip.cboCountry.VALUE,'Countries','cn_Key')
>>
>>Sometimes (not always) when the line is executed it triggers an error: #26 'Table has no index order set'.
>>When I debug it and step through the code, the error does not occur. I have verified that the tag ('CN_KEY') is still there.
>>
>>Any ideas?
>>
>>TIA
>
>Can't answer you directly, but to try and figure it out, rearrange some code. Instead of the above try a few of the following and see if you get the same error:
>
>SELE Coutries
>SET ORDER TO cn_key
>IF SEEK(.ctrZip.cboCountry.VALUE)
>
>OR
>
>SELE Coutries
>SET ORDER TO cn_key
>SEEK .ctrZip.cboCountry.VALUE
>IF FOUND()
>
>Your findings might reveal a little about what is going on.

I put Select Countries just before the line in question and sure enough it never triggered an error again.
Now any ideas why it failed in the first place? I've been SEEKing from other work areas for years and never had it fail before.