>>>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.

I don't know. The only clue I might throw in is the known bug where a REPLACE in another work area will fail if the cursor in the current work area is at EOF().

I would guess that this bug is only a manifestation of a deeper problem, one that you might have stumbled upon.