Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Bug in VFP9, SP1???
Message
De
20/12/2005 09:22:11
 
 
À
20/12/2005 09:14:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01079481
Message ID:
01079513
Vues:
34
>>Is this a bug? I can reproduce it at will.
>>
>>Table has 3 fields:
>>---------------------
>>k_seqno - autoinc intiger
>>k_memo - intiger
>>textln - 65 byte chr.
>>
>>1 index - on k_memo (I forgot to index on k_seqno.)
>>
>>If I open the table with:
>>
use bsmemo order k_seqno
>>I get no error message but show status shows that only the k_memo index exists and the Master Index is set to k_memo. I assume I should have gotten an error on the use command since the k_seqno index does not exist. Worse, the index is set to the wrong field. This just cost me a few hours of hair pulling.
>
>I have ead the whole thread, and I must agree with Fabio that this is not a bug. However, if you rally want an error to be triggered for a missing index tag, you can use this syntax
>use bsmemo order ("k_seqno")
You dont need the extra parentheses, just:
use bsmemo order "k_seqno"
or even (to be absolute certain):
use "bsmemo" order "k_seqno"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform