Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is seek causing this error?
Message
From
10/07/1998 19:26:01
 
 
To
10/07/1998 15:57:03
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00116280
Message ID:
00116372
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform