>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
Bill,
We've had this error intermittantly, and the problem wasn't the SEEK() (although that caused OTHER problems). It was that the WIN NT network occasionally wasn't loading the CDX when it loaded the table. OK, I know that 'never' happens. We have a memo field in the error handler that stores the STATUS code, and were VERY surprised to see the table in question loaded with NO indexes.
Try adding this to your error handler - even a screen display when the error 26 happens - and check it.
HTH
Barbara