>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.
Erik Moore
Clientelligence