Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is seek causing this error?
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00116280
Message ID:
00116397
Views:
23
>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
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform