Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is seek causing this error?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00116280
Message ID:
00116397
Vues:
22
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform